Enter missing date in fact table

Anonymous — Mon, 13 Apr 2015 13:57:19 GMT

Hi guys,

Could you please help me on below issue.

I have attached my data herewith. after 11th row date filelds are in different format. I have requirement on

Where ever the Dates are missing in the fact table then i need to write a code to insert that dates as well and carry forward the previous month closing balance to the next missing dates

Re: Enter missing date in fact table

fvelascog72 — Mon, 13 Apr 2015 14:23:21 GMT

Hi,

Try this:

if(num([Start Date])<50000,[Start Date],

if(len(num([Start Date]))=7,

date(Date#('0'&[Start Date],'DDMMYYY')),date(Date#([Start Date],'DDMMYYY')))) as "Start Date"

topic Enter missing date in fact table in QlikView

Enter missing date in fact table

Re: Enter missing date in fact table