topic Previous 6 months sum in Script level ? in QlikView

Previous 6 months sum in Script level ?

ganeshreddy — Mon, 22 Jun 2015 11:25:50 GMT

Hi All,

How can i calculate previous 6 months Sales here in below script.

Note: In UI level i can achieve this, finding difficulty to calculate in script level .

Thank You,

Cheers,

Ganesh

Anonymous — Mon, 22 Jun 2015 11:31:01 GMT

use set analysis

sum({<yourdatefield={'>={$(=addmonths(max(yourdatefield),-6))}<=yourdatefield{$(=max(yourdatefield))}'}>}sales)

maybe you need to adjust expression

ganeshreddy — Mon, 22 Jun 2015 11:41:33 GMT

Hi Rudolf,

I suppose we can not use set analysis in script. I want to calculate in Script as like Sum(Sales) which i did in script.

Cheers,

Ganesh

giakoum — Mon, 22 Jun 2015 11:46:11 GMT

something like the attached?

giakoum — Mon, 22 Jun 2015 11:48:33 GMT

note the set statement :

SET DateFormat='DD/MM/YYYY';

and use a calendar :

abhaysingh — Mon, 22 Jun 2015 12:13:22 GMT

Hi ioannis,

if i want Current Month vs next 3 rolling month than what i need to do?

thanks

giakoum — Mon, 22 Jun 2015 13:12:06 GMT

AsOfMonth:

load

Month as Month_AsOf,

Month + 1 + IterNo() as Month

Resident tmp_SO

while IterNo() <= 3;

plus in IterNo instead of minus

and 3 instead of 6 in the while clause

pratap6699 — Mon, 22 Jun 2015 14:41:36 GMT

sum({<datefield={">=$(=addmonths(max(datefield),-6))<=datefield$(=max(datefield))"}>}sales)

use if() in script level