Discussion board where members can get started with Qlik Sense.
I have created the following Qlik Sense pivot table:
I want to hide rows with empty City. Totals and subtotals shoud be left as is .
Any idea how to solve this?
Put this - Where City > 0 at the end of the script.
May be try this
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.
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