topic Re: Show Missing value as 0 in report in QlikView

Show Missing value as 0 in report

Fri, 31 Jul 2015 04:24:15 GMT

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.

Re: Show Missing value as 0 in report

puttemans — Fri, 31 Jul 2015 10:19:59 GMT

How does your variable sale cost look like when there is no cost? a blank, or a '-', or another sign?

Re: Show Missing value as 0 in report

avinashelite — Fri, 31 Jul 2015 10:20:07 GMT

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

Re: Show Missing value as 0 in report

Fri, 31 Jul 2015 10:32:42 GMT

Hi,

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.

Thanks.

Re: Show Missing value as 0 in report

Fri, 31 Jul 2015 10:33:58 GMT

Hi,

I already set it but it doesn't worked because that month I need to show is no transaction.

If have another way please help.

Thanks.

Re: Show Missing value as 0 in report

Kushal_Chawda — Fri, 31 Jul 2015 10:44:56 GMT

1) In Dimension make sure that suppress null values is unchecked for Month.

2) try this expression - Alt(YourExpression,0)

3) In presentation tab uncheck Suppress zero value

Re: Show Missing value as 0 in report

Kushal_Chawda — Sat, 01 Aug 2015 17:26:24 GMT

any luck?

Re: Show Missing value as 0 in report

ogster1974 — Sat, 01 Aug 2015 17:45:09 GMT

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.

Regards

Andy

Re: Show Missing value as 0 in report

qlikviewwizard — Sun, 02 Aug 2015 04:56:08 GMT

Hi Use this.

Hope this will helps you.

Re: Show Missing value as 0 in report

Mon, 03 Aug 2015 01:45:35 GMT

I tried it before it doesn't worked. I think on that point of data is no value in table so then report will not show the result right?

Re: Show Missing value as 0 in report

Mon, 03 Aug 2015 01:49:06 GMT

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

Re: Show Missing value as 0 in report

qlikviewwizard — Mon, 03 Aug 2015 03:50:09 GMT

Hi,

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

Re: Show Missing value as 0 in report

sasiparupudi1 — Mon, 03 Aug 2015 03:53:42 GMT

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

Re: Show Missing value as 0 in report

Mon, 03 Aug 2015 03:59:35 GMT

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.

Re: Show Missing value as 0 in report

sarfaraz_sheikh — Mon, 03 Aug 2015 04:43:13 GMT

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

Re: Show Missing value as 0 in report

qlikviewwizard — Mon, 03 Aug 2015 05:27:31 GMT

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

Re: Show Missing value as 0 in report

Mon, 03 Aug 2015 06:32:33 GMT

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

Regards,

Techawat