topic Re: How hide and show pivot table in QlikView

How hide and show pivot table

Anonymous — Thu, 16 Feb 2017 10:37:10 GMT

Hi Community,

I have created two pivot table 'Test1','Test2' .

I have one List box in that there two field 'Test1' , 'Test2'.

When i click on List box Field 'Test1' that time hide pivot table 'Test2' and show pivot table 'Test1' and

when i click on List box Field 'Test2' that time hide pivot table 'Test1' and show pivot table 'Test2'.

How i can achive this hide and show condition?

Thanks in advance

Re: How hide and show pivot table

sunny_talwar — Thu, 16 Feb 2017 10:40:17 GMT

Would you ever want to select both and see both at the same time? or is it always one or the other? May be use these conditions if it is always one or the other:

Pivot Table Test1

=FieldName = 'Test1'

Pivot Table Test 2

=FieldName = 'Test2'

Re: How hide and show pivot table

Anonymous — Thu, 16 Feb 2017 11:11:37 GMT

Hi Sunny

Thanks for your quick reply i always want to show only one pivot table.

and i have already used this solution that means i have already written this logic in pivot table layout >>Show >> conditional box but it is not worked.

can you share with me test QVW.

Re: How hide and show pivot table

sunny_talwar — Thu, 16 Feb 2017 11:15:52 GMT

I think it might be best if you can share what you have

Re: How hide and show pivot table

Anonymous — Thu, 16 Feb 2017 12:29:40 GMT

Hi Sunny,

Please refer attached file.

In QVW i have used logic in both pivot table.But when i click class A field both table hide i want only show Pivot table T1 and when i click on class B field i want to show only pivot table T2.

I have used same logic in my server application but it is not work.

is any setting i have to do for this?

Re: How hide and show pivot table

sunny_talwar — Thu, 16 Feb 2017 12:35:06 GMT

You forgot the single quotes

=Class='B'

=Class='A'

Re: How hide and show pivot table

Anonymous — Thu, 16 Feb 2017 13:22:18 GMT

Hi Sunny,

Your logic working properly.

Thanks for you help