Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ho to show average line with bar chart

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

3 Replies
Not applicable
Author

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

laddu_927
Specialist
Specialist

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