topic Re: Missing dates Should Appear in QlikView

Missing dates Should Appear

narband2778 — Mon, 08 Sep 2014 13:16:32 GMT

Hi Qlik Experts,

Is there anyway if the value is 0 we can force in a zero so that the date appears?

I mean to say for some particular dates I am getting Total as zero from my source file, So Date is not recorded. Is there any way can we show value as a zero for that date and Date value should appear

Date	Total
28/05/2004	1
11/04/2014	2
22/04/2014	226
23/04/2014	266
24/04/2014	315
25/04/2014	208
26/04/2014	105
28/04/2014	372
29/04/2014	290
30/04/2014	305
01/05/2014	362
02/05/2014	225
03/05/2014	109
06/05/2014	377
07/05/2014	331
08/05/2014	504
09/05/2014	279
10/05/2014	88
12/05/2014	488
13/05/2014	421
14/05/2014	423
15/05/2014	446
16/05/2014	317
17/05/2014	139
19/05/2014	489
20/05/2014	434

Thanks,

Naresh

Re: Missing dates Should Appear

alexandros17 — Mon, 08 Sep 2014 13:19:09 GMT

If you have a calendar with all the dates then in presentation uncheck the "suppress zero values" box

let me know

Re: Missing dates Should Appear

MK_QSL — Mon, 08 Sep 2014 13:24:03 GMT

1) If you dont have missing dates at all, you need to generate them using Master Calendar.

2) if Dates are there, but it's not appearing due to Total is 0, go to presentation tab and untick Suppress Zero Values