topic Scripting in QlikView

Scripting

Thu, 17 May 2012 16:02:08 GMT

Hi All,

Can anyone tell me how to calculate privious 12 months sales in script.

oscar_ortiz — Thu, 17 May 2012 22:32:57 GMT

You're going to have to be a bit more specific if you want any help with this...

Anonymous — Thu, 17 May 2012 22:40:34 GMT

Kushal,

When creating my calendar table in my script, I usually have a line like this that creates a flag.

IF(TempDate >=ADDMONTHS(MonthStart($(varToday)),-11),1,0) AS Current12MonthFlag,

Then you can use set analysis to only pull sales for that flag:

SUM({<Current12MonthFlag={1}>}Sales)

Hope this helps!