Ho to show average line with bar chart

[#1]

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

[Anonymous]

Try using a combo chart. https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Visualizations/ComboChart/create-combo-...

[#3]

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

[Anonymous]

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