Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

Pivot Table columns and totals

Another question I am afraid!

I have some data in a pivot table, but I have a few questions.  The table is currently like this:

Pivot Table.jpg

Question 1:

Is it possible to hide the null column?  If I hide nulls in the options it will hide the Claims row as well, and I don't want that.

Question 2:

Is it possible to get the null values in for example the Quotes row to show as a 0?

Question 3:

How do I get the column totals to show?  Currently the formula in the measure is:

count([Market Minimum Band])/count(total <Category>[Market Minimum Band])

Question 4:

Is it possible to force an extra column in.  Between At Minimum and Good there is the possibility of Above Minimum - but in this case there is no data - for consistency I would like to show all the columns at all times - even if they are just 0's.

All help gratefully received.  Is a Pivot Table the wrong visualisation?

Many thanks


1 Reply

Re: Pivot Table columns and totals

Regarding Question1:

I think there are two places you can control how Sense is displaying NULL / Zero, there is a setting for each dimension and a setting on AddOns - Data handling.

Have you tried the setting for the specific dimension?