Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created the following Qlik Sense pivot table:
Country | State | City | Amount |
---|---|---|---|
USA | 8 000 | ||
Alabama | 4 500 | ||
Montgomery | 1 000 | ||
Birmingham | 2 000 | ||
Mobile | 1 000 | ||
Hoover | 500 | ||
Quebec | 1 000 | ||
1 000 | |||
Ontario | 2 500 | ||
2 500 |
I want to hide rows with empty City. Totals and subtotals shoud be left as is .
Any idea how to solve this?
Regards,
R
HI
try some thing like this
if(sum(Amount)>0,City)