topic Re: filling missing data from previous in QlikView

filling missing data from previous

gauthamchilled — Fri, 11 Dec 2015 08:52:46 GMT

Hi,

I have only quarterly data. I want to make it monthly. I currently have data for mar,jun,sep and dec.
i want from jan to dec. Meaning...

for

jan-previousyear dec data
feb-previousyear dec data
mar- actual march data
apr- march data
may-march data
jun- actual jun data
jul-jun data
aug-jun data
sep- actul sep data
oct-sep data
nov-sep data
dec-actual dec data

i following generate missing data by HIC by couldnt succeed, any one help pls

Re: filling missing data from previous

settu_periasamy — Fri, 11 Dec 2015 12:19:41 GMT

Hi Gautham,

Check the Attachment. May be helpful.

Re: filling missing data from previous

gauthamchilled — Mon, 14 Dec 2015 01:46:43 GMT

Hi Settu,

When I use your example, it is not still showing the quarter dates after join.

While I debug by renaming Date as Date 1 , I could see all the dates in Date1, but to join(Date instead of Date1) I see quarterly dates only

Load Date(Floor(Addmonths($(vMinDate),RecNo()-1))) as Date1 Autogenerate vMaxDate-vMinDate;

can you help?

Re: filling missing data from previous

settu_periasamy — Mon, 14 Dec 2015 02:14:14 GMT

Hi Gautham,

is it possible to provide the expected output in excel?

Re: filling missing data from previous

gauthamchilled — Mon, 14 Dec 2015 02:48:43 GMT

Settu,

Thanks for your help.

If I select ABC it should show sales for all the dates, if I select DEF it should show for all the dates.

If actual data is null, then it should pick from previous available data and show. Currently it is not showing for all the dates in your example.

Re: filling missing data from previous

gauthamchilled — Mon, 14 Dec 2015 02:58:04 GMT

for selection ABC expected output is

31/12/2014	ABC	3000.00	2014	Dec
31/01/2015	ABC	3000	2015	Jan
28/02/2015	ABC	3000	2015	Feb
31/03/2015	ABC	4000	2015	Mar
30/04/2015	ABC	4000	2015	Apr
31/05/2015	ABC	4000	2015	May
30/06/2015	ABC	9000	2015	Jun
31/07/2015	ABC	9000	2015	Jul
31/08/2015	ABC	9000	2015	Aug
30/09/2015	ABC	4000	2015	Sep
31/10/2015	ABC	4000	2015	Oct
30/11/2015	ABC	4000	2015	Nov
31/12/2015	ABC	4000	2015	Dec

Re: filling missing data from previous

gauthamchilled — Mon, 14 Dec 2015 03:03:09 GMT

Also, if I select 2014 year it is showing 2015 dates mixed with 2015 in your example

Re: filling missing data from previous

MayilVahanan — Mon, 14 Dec 2015 04:32:42 GMT

PFA

May be its help

Re: filling missing data from previous

gauthamchilled — Mon, 14 Dec 2015 05:49:52 GMT

Thanks Mayil,

May I know why Date and Date 1 is not joining ?

Re: filling missing data from previous

MayilVahanan — Mon, 14 Dec 2015 08:35:52 GMT

For create cross join