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
Put this - Where City > 0 at the end of the script.
May be try this
not tested
Data handling tab--condition-- city>0
To be more specific, I don`t want subtotals for City dimensions to be displayed when there is only 1 dimension position.
So do you want to exclude any cities where the field is null
when len(city) =0
So in the above example only include Alabama.
No. I want all cities it to be included in Totals but without subtotals which are obsolete when there is only one position ( - ).
Go to chart properties and select suppress when certain fields is null.
or
Use straight table instead of pivot table, however you will not have any totals for city field.
I doubt if you can do this as the report wouldn't add up.
Out of interest why would you want to do this. Have a report where the subtotals don't add up to the total?
If I was ever asked t do something like this I would set up a new state field (say StateNoCity) to convert a state without a city into State > other. Using if statements