Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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

Dear QVExpert,

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
Close00
Bestcase00
Commit00
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,

Nirav Bhimani

21 Replies
Highlighted
Specialist III
Specialist III

Uncheck the "Supress Zero Values".

Highlighted
Specialist
Specialist

In the Presentation Tab

Last we have the Options like

Null Symbol -

Missing Symbol -

Replace the '-'(Hypen) with Zero('0')


Highlighted
Partner
Partner

HI,

My requirement is when I dont have any data for the Direct reportees User & Forecast category but still I need to show the output with 0 value like below.

Forecast CategoryDirect Reportees NameJonTom
Close00
Bestcase00
Commit00
Pipeline00
Highlighted
Specialist III
Specialist III

Could you please upload sample qvw?

Highlighted
Specialist II
Specialist II

Hi Nirav,

Please find attached image for your reference..

Go to presentation tab -> click on appropriate expression and apply Missing Symbol as 0.

Hope it will work for you.

-- Regards,

Vishal Waghole

Highlighted
Partner
Partner

Dear All,

Right now I am getting the following output, Bcoz there is no data associated to reportees & Forecast Category, So when I cross check the Forecast category all the values coming in gray, So due to that qlikview is showing "-" i.e. Null. But my requirement is that even if values are not there then also I need to show the data as I posted in my above post. 

Forecast CategoryDirect Reportees Name-
-0

Regards,

Nirav Bhimani

Highlighted
Specialist II
Specialist II

Hi Nirav,

also need to uncheck "Suppress Zero Values".

-- Regards,

Vishal Waghole

Highlighted
Partner
Partner

HI,

I already did that, what I am saying is when I dont have any data in the database related to that Forecast category & reportees under him then also I want to display all 4 category as Close, Commit, Pipeline & Bestcase with respect to their reportees name & Expression value should be 0.

Regards,

Nirav Bhimani

Highlighted
Specialist II
Specialist II

Hi Nirav,

If possible then please add some sample data and expected output.

i can try to accomplish with your dummy data.

-- Regards,

Vishal Waghole