topic Re: Discrete Date Info - make continuous in QlikView

Discrete Date Info - make continuous

tresB — Tue, 21 May 2013 06:36:35 GMT

Hello,

I have a data set for discrete dates. I have to show the data as continuous information. That is, if i have data for 1st Jan and 10th Jan, i have to show the 1st Jan data for 2nd to 9th Jan. Please find the attached excel for detailed data explanation. I want to achieve the same in script. It is a kind of FOR THE DATE reporting.

Thanks.

Re: Discrete Date Info - make continuous

somenathroy — Tue, 21 May 2013 08:43:42 GMT

PFA. hope it helps.

Regards,

Som

Re: Discrete Date Info - make continuous

tresB — Tue, 21 May 2013 09:00:54 GMT

thank you Som for your effort. though your output is not exactly what i wanted, but your script gives me a fair idea. i wanted to populate missig rates for dates from historical rate(may be using PEEK function). i will go through yor script in details and try.

Thanks.