Qlik Sense - hide row in pivot table

Anonymous — Fri, 15 Jun 2018 11:18:16 GMT

Hi,

I have created the following Qlik Sense pivot table:

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,

Re: Qlik Sense - hide row in pivot table

Chanty4u — Sun, 17 Jun 2018 16:40:05 GMT

try some thing like this

if(sum(Amount)>0,City)