Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

last 6 month

hi ,

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

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

thanks'

yarin

3 Replies
felipe_dutra
Partner - Creator
Partner - Creator

Try this:

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


Felipe

Anonymous
Not applicable
Author

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
Partner - Creator
Partner - Creator

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