Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rafal_dudka
New Contributor

Hide dimension element in pivot table

Hi,

I have created the following Qlik Sense pivot table:

CountryStateCityAmount
USA8 000
Alabama4 500
Montgomery1 000
Birmingham2 000
Mobile1 000
Hoover500
Quebec1 000
1 000
Ontario2 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

7 Replies
isingh30
Contributor III

Re: Hide dimension element in pivot table

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

sureshqv
Esteemed Contributor III

Re: Hide dimension element in pivot table

May be try this

not tested

Data handling tab--condition--  city>0

rafal_dudka
New Contributor

Re: Hide dimension element in pivot table

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

robert99
Valued Contributor II

Re: Hide dimension element in pivot table

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.

rafal_dudka
New Contributor

Re: Hide dimension element in pivot table

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
Contributor II

Re: Hide dimension element in pivot table

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
Valued Contributor II

Re: Hide dimension element in pivot table

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

Community Browser