creating an inline table with the last 60 dates

Sat, 09 Jun 2012 16:29:38 GMT

I am terribly new to Qlikview, forgive me if this is old hat (though I searched a lot without finding a definite solution).

Let's say I have a bar chart to show my last 60 days of sales performance. Occasionally we have a day with zero sales. But I want that to show, too. If I set the dimension to be the "date of sale" then those zero bars will not show. I want to force the chart to show stats, even if zero, for 60 periods.

One way I thought might work, would be to Load Inline a table consisting of the last 60 dates, and then use it as the dimension for the bar chart. That way it would keep the dates fresh, no hardcoding, and there would never be a missing date when we have no sales. But the inline load system doesn't like any of the formulas I tried for obtaining a date, it just loads them, not their calculated values. I also tried a DO...WHILE loop to inline-load the 60 dates, and again couldn't get real dates into the table, just formulas.

Thank you in advance for any advice that you might have!

Hanno

Maryland & Deutschland

Re: creating an inline table with the last 60 dates

jagan — Sat, 09 Jun 2012 18:44:59 GMT

Hi,

Use AutoGenerate with Load. Try something like this

TempDates:

Load

Date(Today() - RecNo( )) as Dates

autogenerate(61);

Regards,

Jagan.

Re: creating an inline table with the last 60 dates

Sun, 10 Jun 2012 13:11:21 GMT

Thank you Jagan, that works great!

Hanno

topic Re: creating an inline table with the last 60 dates in QlikView

creating an inline table with the last 60 dates

Re: creating an inline table with the last 60 dates

Re: creating an inline table with the last 60 dates