topic Re: Show the Table based on selection otherwise it hidden. in QlikView

Show the Table based on selection otherwise it hidden.

Thu, 16 Jul 2015 05:26:32 GMT

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 — Thu, 16 Jul 2015 05:28:46 GMT

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 — Thu, 16 Jul 2015 05:32:10 GMT

Hi,

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

Regards

tresB — Thu, 16 Jul 2015 05:35:03 GMT

Or, even wihtout IF, like:

=getselectedcount(fieldname)

Kushal_Chawda — Thu, 16 Jul 2015 05:37:13 GMT

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 — Thu, 16 Jul 2015 05:41:19 GMT

Try like this

chart properties -> Layout -> conditional

= Getselectedcount(FieldName1) or Getselectedcount(FieldName2)

Thu, 16 Jul 2015 05:59:39 GMT

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