topic Re: How to show zero values in Pivot even if data is not present in DB in QlikView

How to show zero values in Pivot even if data is not present in DB

chinnuchinni — Sat, 16 Nov 2024 02:48:46 GMT

Hi All,

I have requirement where I have a table which contains Forecast Category & Direct reportees Name as a Dimension & One Expression which shows the Revenue. So if I select Manager name & month Year as a selection then I want to display the ppl under him & their Revenue, My problem is only when I select manager & month if there is no data associated with that direct reportees then it is showing null value in the dimension, so instead of that it should show all Dimension data with 0 values as below table.

Note: I want the following Output in Pivot Table.

Forecast Category	Direct Reportees Name	Jon	Tom
Close		0	0
Bestcase		0	0
Commit		0	0
Pipeline		0	0

Currently due to no data present its showing like this,

Forecast Category	Direct Reportees Name	-
-		0

Can you please guide me how can I achieve this.

Thanks & Regards,

Praveen

Re: How to show zero values in Pivot even if data is not present in DB

Claudiu_Anghelescu — Tue, 06 Aug 2019 10:07:27 GMT

https://www.youtube.com/watch?v=TRJrG-hW1Yo

Re: How to show zero values in Pivot even if data is not present in DB

yassinemhadhbi — Tue, 06 Aug 2019 10:30:04 GMT

In the presentation Tab , check surpress zero-values

Re: How to show zero values in Pivot even if data is not present in DB

Brett_Bleess — Mon, 26 Aug 2019 12:57:40 GMT

Praveen, have a look at the following Help link:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/sum-of-rows-pivot-tables.htm

If one of the other posts did the trick, please be sure to give credit by clicking the Accept as Solution on the one(s) that did help, but if you are still working on things, this might be another avenue potentially.

Regards,
Brett