Filter selection in pivot table

[tan_chungkam]

Hi all,

I have 3 sheets in  the app.

Is there anyways to show only A instead of A B C in Asia Sheet and show only B in Europe.

Please find attach as my qvf file. Thanks.

[imsushantjain]

Hi Kam,

You can use set analysis to restrict the set of data to be displayed in each sheet. For more info please refer to the link:

https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/

SJ

[tan_chungkam]

hi Sushant,

Thanks for the prompt reply.

Would you able to try it in my qvf file?

What i want is the table should only show 1 column which is A. I had used the set analysis to restrict the figure of Asia and Europe.

Much appreciate if you could show it to me. Thanks.

[ChennaiahNallani · Accepted solution]

Try like below

[Neymar_Jr]

Hi,

May be like in the attached