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: 
Not applicable

SUM of sales of selected month and previous 2 months.

I have an expression for calculating the 3 months average from the selected month.

Suppose if Aug 2012 is selected then it would sum up June,July, August sales.
but when i introduce the Date ( MM/DD/YYYY) format as the dimension then it doesnt seem to work.
It only does the sum of current month.

I use the xpression sum({<Month Name={$v(Date)}>}sales) where vDate =Aug,Jul,Jun if the selected month is Aug.
this expression works well till no date field is introduced as dimension .
On addition of date field
suppose if
Aug Sales=30

Jul=20

Jun=10 then instead of showing 60 it shows 30 only .

0 Replies