Date Generation Independent of Data

[#1]

Hi.

I have a small requirement.

Suppose, my date column of the table is recording data on the basis of the task happened. Now say, on holiday, there won't we any data recoding hence, the data for that particular date is empty. If we load data from that date column  to qlikview then date which were recorded in the table only displayed , missing date were omitted automatically.

What I want is, I want to create an external date range in qlikview script which generate all date irrespective of date recorded in the table but will be linked with them. Now if someone click on the date which is not in the table, it still shows the all charts with no value.

I attached the XLS and QVW.

Please have a look at them.

Thanks.

Sachin A.

[#2]

Hi,

Can anyone please look this ?

Thanks

Sachin A.

[kaushiknsolanki · Accepted solution]

Hi,

   Here is the solution.

   Have a look at the attached document.

Regards,

Kaushik Solanki

[qliksus]

Try uisng the autogenerate function to generate  date

a:
LOAD DateX,
     Value
FROM

(ooxml, embedded labels, table is Sheet1);

b:
load max(DateX)-min(DateX) as cnt,MinString(DateX) as min
Resident a;

let Firstdate = Peek('min',0,'b');

let Totalvalue = Peek('cnt',0,'b');

load if(RecNo()=1,$(Firstdate),$(Firstdate)+RecNo()-1) as DateX

AutoGenerate($(Totalvalue)+1);

This will create all the dates between the start and end date present in you excel