Discussion Board for collaboration related to QlikView App Development.
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.
simple solution would be , if its a straight or pivot table than go to presentation tab and you will see the representation for the null and missing as - ...change it to 0 it will work ......
if you need it in the script level we have the other ways to achieve it , please let me know if you need that
In Presentation tab I set the missing symbol to 0 and null to "-" but in the month that no transaction was not show in report but I need to show it as 0.
Please provide the script.
Sounds like you need a master calendar created in your data load to use as your dimension to link to your fact data.
That way if you miss months in your data you wont have any gaps.