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

[nirav_bhimani]

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 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,

Nirav Bhimani

[senpradip007]

Uncheck the "Supress Zero Values".

[Anonymous]

In the Presentation Tab

Last we have the Options like

Null Symbol -

Missing Symbol -

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

[nirav_bhimani]

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 Category	Direct Reportees Name	Jon	Tom
Close		0	0
Bestcase		0	0
Commit		0	0
Pipeline		0	0

[senpradip007]

Could you please upload sample qvw?

[VishalWaghole]

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

[nirav_bhimani]

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 Category	Direct Reportees Name	-
-		0

Regards,

Nirav Bhimani

[VishalWaghole]

Hi Nirav,

also need to uncheck "Suppress Zero Values".

-- Regards,

Vishal Waghole

[nirav_bhimani]

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

[VishalWaghole]

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