topic Re: last 6 month in QlikView

last 6 month

Anonymous — Tue, 17 Jun 2014 03:00:44 GMT

hi ,

how can i create colculte the last 6 month in the next formula :

sum ({$<_Flag={Inv,InvAdel}>}[kg])

thanks'

yarin

felipe_dutra — Tue, 17 Jun 2014 03:17:33 GMT

Try this:

sum ({$<_Flag={Inv,InvAdel}, Date={">=$(=MonthStart(Today(), -6))"}>}[kg])

Felipe

Anonymous — Tue, 17 Jun 2014 03:32:20 GMT

hi ,

thanks' but the calculte is without the month that in last year , for exm:

my dimension is 2014 may,

i expect to see the resoult for apr,mar,feb,jan,dec(13),nov(13).

is it possible ?

yarin.

felipe_dutra — Tue, 17 Jun 2014 03:50:36 GMT

sum ({$<_Flag={Inv,InvAdel}, Date={">=$(=MonthStart(Max(Date), -6))<$(=MonthStart(Max(Date)))"}>}[kg])