topic Re: Show percentage in pivot table in App Development

Show percentage in pivot table

Tue, 20 Dec 2016 08:41:00 GMT

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:

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?

Re: Show percentage in pivot table

Gysbert_Wassenaar — Tue, 20 Dec 2016 08:46:47 GMT

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

Re: Show percentage in pivot table

Tue, 20 Dec 2016 08:52:35 GMT

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?

Re: Show percentage in pivot table

vinieme12 — Tue, 20 Dec 2016 08:59:16 GMT

uncheck suppress zero values

Re: Show percentage in pivot table

Tue, 20 Dec 2016 09:03:08 GMT

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

Re: Show percentage in pivot table

sunny_talwar — Tue, 20 Dec 2016 13:06:53 GMT

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

NULL handling in QlikView