Suppress rows of a Pivot Table based on dimensions values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi, Qlik newbie here and working on my first qlikview report

I have a pivot table with 2 dimensions

Expression is a Sum of Returns

How can I suppress the entire row based on 2 conditions

1. Country = USA, CHINA AND sum is > 0

2. Sum > 0 for all Countries

Example Pivot Table:

Product	Total	USA	CHINA	GERMANY
Wrench	50	10	40	-
Spanner	2	-	-	2
Hammer	100	10	80	10

The outcome based on the above should only show the Wrench and the Hammer Rows

Any feedback is appreciated, thanks

Re: Suppress rows of a Pivot Table based on dimensions values

sunny_talwar — Tue, 17 Jul 2018 15:53:27 GMT

Why is Spanner not shown? It does meet the second condition of Sum > 0? or this is an and condition? If it is, then try this

May be this

Sum({<Product = {"=Sum({<Country = {'USA', 'CHINA'}>}Returns) > 0 and Sum(Returns) > 0"}>}Returns)