how to hide bar chart & pivot table URGENT

[renuka_sasikumar]

I have 2 pivot table & one bar chart and a list box.

Now I want to give condition where Wen i select anything in list box i should get only one pivot table and wen I clear all i should get the rest 1 pivot table and the bar chart.

How do i go about it.

pls help its urgent

[its_anandrjs]

Hi,

Use GetSelectedCount(Fieldname) and check the count value.

Thannks & Regards

[MK_QSL]

go to properties >> Layout Tab >> Show >> conditional

Write below as an expression

For 1 Pivot Table

NOT ISNULL(GetFieldSelections(YourFieldNameWhichYouUseinListBOX))

For other Pivot Table and Bar Chart

ISNULL(GetFieldSelections(YourFieldNameWhichYouUseinListBOX))

[#4]

Hi Renuka,

You can make the pivot table and bar charts layout conditional. Right click on the chart/table, go to Properties--Layout tab. In the "Show" section, click on "Conditional" and give your condition.

In your case for example if the list box field is Month then to show first pivot table write:

=GetSelectedCount(Month) <>0.

For others you can write

=GetSelectedCount(Month) = 0

Hope this helps, if not please share a sample app.

[#5]

Hello Renuka,

if i understand your Requirement correctly, you can do this way.

Piovot->Properties->Layout->Select Conditional under Show and have this condition

=if(isnull(GetcurrentSelection(Field)),1,0), this condition will hide the pivot if you select anything in the chart and comes back if nothing.

Hope this helps.

Thanks & Regards,

Venkat T

[renuka_sasikumar]

Thanks I did this

It is working.

[its_anandrjs]

Hi,

Write some thing like

For pivot table that you want to hide when select any thing in list box

go to -> Chart properties -> Layout -> Show -> Conditional -> type this code  =if(GetCurrentSelections(YourListboxfield)>1,0,1)

For second chart same

go to -> Chart properties -> Layout -> Show -> Conditional -> type this code  =if(GetCurrentSelections(YourListboxfield)>1,0,1)

Hope this helps

Thanks & Regards