Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am new in Qlik Sense.
Anybody can explain how to show 3 month average line with bar chart. As of know showing individual last 12 months data in bar. I want to display also 3 month average line. Please advise how is it possible.
Thanks in advance
Regards,
Ankit Singh
Thanks Shiva for quick reply
Now I've taken combo chart and add another measures for show average line average. But what expression i have to used for show each 3 months average out of 12 months.
Regards
Ankit Singh
Ankit, I think three months are we referring to here, selected month,month-1, month-2 ??
create a monthnum field for your months and then
try something like Avg({<MonthNum = {"$(='>=' & Max(MonthNum)-2) $(='<=' & Max(MonthNum)) "}, Month>}Amount).
Hope it helps