Show Missing value as 0 in report

[#1]

Hi,

I create report to show sale cost and in some month don't have sale cost but I need to show value as zero in report when select "Show All Values" for a dimension in Dimension tab report show all value in database include data I don't need to show in report.

[#2]

I already have table of master calendar but I think data don't have on that point then the report will not show any row.

Have any way to bring temp data for show in report?

Regards

[qlikviewwizard]

Hi,

Can you attach the sample file to demonstrate your issue. Thank you.

[sasiparupudi1]

Please post your application indicating the problem dates and the grids where uou want to display zero

[#5]

Hi,

Now my data have as of Mar-2016 and I need to show Data to Jun-16 but the month from Apr-16 to Jun-16 have no transaction so I need to show it as zero.

Thanks.

[sarfaraz_sheikh]

Dear Techawat,

You need to add dummy zero in that. please see below post ....i also faced the same problem before.

How to create static dimension in pivot table

Sarfarz

[qlikviewwizard]

It is fine. But add the sample file to provide you the solution.

[#8]

Thanks for your help I'll try this action in my report.

Regards,

Techawat