Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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