Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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

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 CategoryDirect Reportees NameJonTom
Close 00
Bestcase 00
Commit 00
Pipeline 00

 

Currently due to no data present its showing like this,

Forecast CategoryDirect Reportees Name-
- 0

 

Can you please guide me how can I achieve this.

  

Thanks & Regards,

Praveen

Labels (1)
3 Replies
Highlighted
Specialist
Specialist

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

https://www.youtube.com/watch?v=TRJrG-hW1Yo
To help community find solutions, please don't forget to mark as correct.
Highlighted
Contributor III
Contributor III

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

In the presentation Tab , check  surpress zero-values

Highlighted
Digital Support
Digital Support

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

Praveen, have a look at the following Help link:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.