Discussion board where members can get started with QlikView.
How can I calculate of last three months average sales based on my selection?
As an example,if I select Aug-18 then calculated average sale should be of '(June-18 + July -18 + Aug - 18)/ 3'
Thanks in advance
sent...can you please check.....
ok, I see your problem..
you were making selections on FMonthName and you didn't detach it from the set analysis:
try this exact expression on your AvgSales formula:
View solution in original post
Thanks dear...It works 😄