Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Show percentage in pivot table

I have a pivot table:

Column dimensions: country, tax_class

Row dimension: if(status=0, age) //suppress null values

Measure #: count(distinct product_name)

Measure %:

I want to show the percentage against the totals at the top. I tried count(distinct product_name)/count(total <age> distinct product_name), but it shows the following:

pivot.JPG

Another question:

There are some dash '-' in the table. They are supposed to be 0. Why does it show - instead of 0? Can this be fixed?

1 Solution

Accepted Solutions

Re: Show percentage in pivot table

Try count(distinct product_name)/count(total <country,tax_class> distinct product_name)


talk is cheap, supply exceeds demand
5 Replies

Re: Show percentage in pivot table

Try count(distinct product_name)/count(total <country,tax_class> distinct product_name)


talk is cheap, supply exceeds demand
Not applicable

Re: Show percentage in pivot table

Wonderful. This works!

Another question if you don't mind:

There are some dash '-' in the table. It is supposed to be 0. Why does it show dash instead of 0? Can this be fixed?

vinieme12
Esteemed Contributor II

Re: Show percentage in pivot table

uncheck  suppress zero values

Not applicable

Re: Show percentage in pivot table

I already check "show zero values". But some zero values are shown; some are not

Re: Show percentage in pivot table

Look here to check out the difference between null and missing value

NULL handling in QlikView

Community Browser