topic Re: Pivot calculation showing as “-“ rather than “0%” in QlikView

Pivot calculation showing as “-“ rather than “0%”

mohiahmed — Sat, 16 Nov 2024 05:07:53 GMT

I need help on a pivot calculation please. Used a simple sum to show % if few area by month. However when the calculation should be at “0%” it’s showing me “-“. I changed missing symbols in presentation tab to 0% and it shows me correctly where I have a value. Also at times there will be null values to calculate that also showing “0%”which is incorrect. Help will be greatly appreciated thanks.

Re: Pivot calculation showing as “-“ rather than “0%”

kaushiknsolanki — Tue, 27 Nov 2018 10:24:03 GMT

Hi,

Try this.

Num(Alt(Expression, 0), '#,##0.00%')

Regards,

Kaushik Solanki

Re: Pivot calculation showing as “-“ rather than “0%”

mohiahmed — Tue, 27 Nov 2018 11:16:36 GMT

Thank you Kaushik, however I am still getting “-“ in my results after updating the expression. I have attached the expression. Also, do I need to make any changes to presentation tab?