Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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 .

Community Browser