Show the Table based on selection otherwise it hidden.

[#1]

Hi

I need to show a pivot table it based on selection in a multibox or else it should be hidden..............

Can you please tell  me how is it?

[qlikmsg4u · Accepted solution]

Any Particular field in Multi box? Here I'm Assuming your field as Year

Use this in Pivot Chart > Layout > Show Conditional

=GetSelectedCount(Year)>0

[PrashantSangle]

Hi,

go to chart Property->Layout->enter condition->if(getselectedcount(fielname)>0,1,0)

Regards

[tresesco]

Or, even wihtout IF, like:

=getselectedcount(fieldname)

[Kushal_Chawda]

Considering you have 3 fields in multibox as Field1, Field2 and Field3

Go to chart properties -> Layout tab-> check conditional and put below expression there

if(getselectedcount(Field1)> 0 or getselectedcount(Field2)> 0 or getselectedcount(Field3)> 0, 1,0)

[MayilVahanan]

Hi

Try like this

chart properties -> Layout -> conditional

= Getselectedcount(FieldName1)  or Getselectedcount(FieldName2)

[#7]

hi,

I hope it will help u to complete the task

In  a multi box u r holding how many filters in it ?

For  Ex:3 filters x,y,z

if u r going to select x it should display corresponding x filter values in a pivot table

for that

Pivot Chart > Layout > Show Conditional

=GetSelectedCount(x)>0

it will display only for filter 'X'

if it want to work for all the filters dynamically means

Pivot Chart > Layout > Show Conditional

=(GetSelectedCount(x) + GetSelectedCount(y) + GetSelectedCount(z))>0

it will work for all the filters.

Thanks and Regards

Balaji.k