How to filter rows in qlik pivot based on an expression

Tue, 25 Apr 2017 15:26:10 GMT

I want to be able to only show rows in a pivot table where a certain criteria is met. I don't want to use list boxes or any other filter that affects the whole sheet, I only want it to effect this pivot.

Example data below I would only want to see the product if the Tlevel is less than the Clevel.

Product	Tlevel	Clevel
123456	1	5
123457	2	4
123458	3	3
123459	4	2
123460	5	1

Is this possible?

topic How to filter rows in qlik pivot based on an expression in QlikView

How to filter rows in qlik pivot based on an expression