Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tan_chungkam
New Contributor III

Filter selection in pivot table

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.

1 Solution

Accepted Solutions
ChennaiahNallani
Contributor III

Re: Filter selection in pivot table

Try like below

Capture.PNG

4 Replies
imsushantjain
Contributor

Re: Filter selection in pivot table

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
New Contributor III

Re: Filter selection in pivot table

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
Contributor III

Re: Filter selection in pivot table

Try like below

Capture.PNG

rajeshthakur292
Contributor II

Re: Filter selection in pivot table

Hi,

May be like in the attached

Community Browser