ex: suppose if I select month July'16 in list box it should give me average by taking the previous two months and the present month selected as well.I want this to be dynamic across all months. I want to achieve this in Qlikview as a table and also as line graph.
Average of Category tickets count = (present month + past 2 months)/3. If you go to cell 'K11' for 2nd table you will be able to understand what I am trying to explain, if I am not clear.
Example as per Excel sheet:
July'16 Average ticket count: = (I3+J3+K3)/3 = 21
I tried with set expressions and other workarounds but failed to achieve it.