Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
laddu_927
Not applicable

Re: Ho to show average line with bar chart

Not applicable

Re: Ho to show average line with bar chart

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
Not applicable

Re: Ho to show average line with bar chart

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