Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siddharthsoam
Contributor

Can i restrict showing all the values in a pivot row filter

Hi

Is it possible to show empty row filter value in a pivot table. For example I don't want to show value's flashing in  CDG row i.e. {A,B,C} when I select the CDG filter in the pivot.

snip 2911.JPG

Except for filter it should flash in the pivot

snip_2911x2.JPG

3 Replies
OmarBenSalem
Esteemed Contributor

Re: Can i restrict showing all the values in a pivot row filter

Can u rephrase that please? I tried to uderstand the point u're making..but I'm not that sure !

siddharthsoam
Contributor

Re: Can i restrict showing all the values in a pivot row filter

Hi Omar,

I want that whenever I select the CDG filter in row of a pivot it should not show me any option. Is that possible?

OmarBenSalem
Esteemed Contributor

Re: Can i restrict showing all the values in a pivot row filter

In different words; you want to always have all the CDG values in your table and thus eliminate the possibility of filring by CDG column?

Since ur demand is not possible; u can alter ur measure by including {<CDG>}

example:

sum({<CDG>}Sales) : with that, even when u select a CDG's value; it won't affect ur pivot table, and every CDG will still be in the table

Community Browser