How to hide charts by using input control?

[vijaymuniraj]

Hi expert,

I have a requirement in WEBI report like I have 12 charts in my report and user wants to display only what they want. If they wanted to see only 5 charts and they should be able to hide remaining 7 charts.. Is that possible on Webi report????. I used input control and created variable but im able to only hide one chart.

I would be great if i got any workarounds.

Thanks in advance

[kohesco]

easy just do this happy playing

[vijaymuniraj]

Hi Prathmesh Pai  & Saurabh Sonawane,

Sorry if i failed to explain my requirement correctly. Actually i have 12 different Blocks/charts and each Block/chart having 12 months data (i have no problem with this) but if my client think to send only 8 Block/chart as PDF to their customer, they want to hide remaining 4 reports/charts.

My problem is, how to hide remaining 4 reports before they export as PDF/Excel??

Thanks

Vijay Muniraj

[saurabh_sonawane]

hi

do u want to hide report or chart/block

[saurabh_sonawane]

hi

we can hide chart

and sorry we cant hide the report

[vijaymuniraj]

Hey thanks for quick reply. i want to hide chart based on user input.. Here each chart represents each KPI.

Lets say  Chart 1 = KPI 1

              Chart 2 = KPI 2

              Chart 3 = KPI 3

               .

               .

               .

               .

               .

              Chart 12 = KPI 12

Now if my client wants to send this report (12 KPIs) to their customer but my client thinks KPI 2 & KPI 3 is not belongs to some customers. so they need to hide that two charts(KPI 2 & 3) for specific customers. that is the requirement.

Hope you understood. thanks

[saurabh_sonawane]

just create a new variable (select month)

step- create a new input control as Entry field

step2- write a if condition on a chart =If(Match(upper([Select Month]);"*JAN*")=0;0;1)

Note user has to manual Enter the value

User can enter value like JAN,FEB,MAR etc....

OR user can enter C1,C2,C3,C4...............

THEN YOUR FORMULA BECOME

step2- write a if condition on a chart =If(Match(upper([Select Month]);"*C1*")=0;0;1)

THE ABOVE FORMULA WILL HIDE THE CHART 1

[vijaymuniraj]

Ya it should work but now i have two questions.

1. Can we type multiple values on entry field? like if i type C1,C2,C3 on entry field, will it hide those 3 charts?..

2. Is there any other workaround where we can select multiple charts from list? like check box?

Thanks

[Former Member]

Hi Vijay,

Create a Variable

1) Select No of Charts = " " (Variable Name is No of Charts and don't include anything in formula)

2) Create input control on above created  variable and Pass custom values 1,2,3,..12 into it.

3) Arrange all the 12 Charts in Order.

4) Apply Hide Dimension on each Chart.

Like    For chart 1, It should appear always, so no need of hiding.

          For Chart 2, Hide- Hide when (Not(Report Filter([Select No of Charts]) inlist (2;3;4;5;6;7;8;9;10;11;12)))

          For Chart 3, Hide - Hide when (Not(Report Filter([Select No of Charts]) inlist (3;4;5;6;7;8;9;10;11;12)))

          For Chart 4, Hide - Hide When (Not(Report Filter([Select No of Charts]) inlist (4;5;6;7;8;9;10;11;12)))

....

Repeat the same for other charts too.

Refer the below Link for reference.

http://blog.davidg.com.au/2011/09/dynamic-measures-in-webi-on-any-data.html

[saurabh_sonawane]

yes

the above method will work for multiple selection

we had made formula like that only that user can enter multiple value

just enter more text with separated with space or comma it will work 

yes

just create a variable in bex with contain 1 to 12 values only.

and use that variable in INPUT CONTROL (select check BOX)

[vijaymuniraj]

Hi Sujitha,

Ok if i select chart 7 then it will hide and now my question is, how to bring it back if i need?.

I am able to use custom values to only Entry field, Radio button, Combo box and list box (where we are able to select only one value at a time). If this is works for Check box my problem will be resolved.

My client will not accept to type the values manually (using Entry field).

(But This is great idea!!!. i will use it in future even if it's not working for this requirement).

Thanks

[vijaymuniraj]

Hi Sujitha,

Inserting custom values for new variable is what actually i was looking for. I created measure variable (Show/Hide Report) then assigned values 1 to 12 as u told. And enabled chart option Hide when following formula is true (like Saurabh mentioned) then given formula Show/Hide report = 1. Followed for remaining charts also.

Thank u all.

Regards,

Vijay Muniraj

[saurabh_sonawane]

Great

Please close this tread 

[vijaymuniraj]

Guys,

Sujitha Grandhi

Saurabh Sonawane

I'm hopeless again. i'm able to hide only one chart at a time. see the below screen shot.

There is only one values passed to the variable even if i selected multiple values.

in the above image i have selected 2 and 4. so chart 2 & 4 should be displayed(or hide). but whatever i select, the first value which is selected from the top is passed to tat variable. Help me on this.

Sujitha,

was i misunderstood your Idea?

Thanks

[Former Member]

Vinay,

Step 1: Consider this example, it is my sample data

Step 2: Create input control on Week (Check box with Multi selection as you require) and apply input control to the entire page body.

Step 3: Take 6 blocks. Apply Block level filter on each block as shown below.

Step 4: Now, Right click on each block -- Hide -- Apply Hide when Empty.

Step 5: So, now when you select 2, only second block will appear and when you select 2,3 then both blocks will appear.

Regards,

G Sujitha

[vijaymuniraj]

Sujitha,

Thank you very much for your patients.

In your example,

Week is a variable which you created manually and given custom values?

[Former Member]

Vinay, Week is my database column. If required, you can create variable manually and pass custom values.

[vijaymuniraj]

Sujatha,

That's where i'm encountering problem. I assigned custom values to that variable and when i check two or more values, the variable brings only one value (the first selected one).

(the issue is mentioned on my previous screen shot reply)

If it doesn't work, i'm about to think to bring some dummy values from database (with support of BW team)

[Former Member]

Vinay, then it is better to ask your BW team to populate the values.

And if you are okay with having single selection input control rather than creating Input control with multi selection... Refer this thread.

BOBJ Tricks: Dynamic Measures in Webi (on Any Data Source)

[saurabh_sonawane]

Yes it is possible in webi

just create a new variable (select month)

step- create a new input control as Entry field

step2- write a if condition on a chart =If(Match([Select Month];"*jan*")=0;1;0)

Note user has to manual Enter the value

User can enter value like JAN,FEB,MAR etc....

[Former Member]

Hi Vijay,

We had faced a similar situation and this is how we resolved it.

We were using a report filter and not input control.

Scenario:

12 charts - one for each month

Requirement:

Based on month a chart should appear, rest should be hidden

Solution:

We used block level filters on each chart.

The report filter was for month, so only the prompted month would filter out the respective chart and hide the rest.

I hope this helps.

Thanks.