Hide dimension element in pivot table

[Anonymous]

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

[isingh30]

Put this - Where City > 0 at the end of the script.

[Chanty4u]

May be try this

not tested

Data handling tab--condition--  city>0

[Anonymous]

To be more specific, I don`t want subtotals for City dimensions to be displayed when there is only 1 dimension position.

[robert99]

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.

[Anonymous]

No. I want all cities it to be included in Totals but without subtotals which are obsolete when there is only one position ( - ).

[rangam_s]

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.

[robert99]

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