Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

Average Trendline

Hi All,

I have a chart where Bar is showing Dollar valuer per month. And in Line we need show the Trendline Average.

If I use the Trendlines property it is simply dividing by 12. Instead of that I need Sum(Dollar) / Available Month in Current Year.

Is there any other property to do the same.

Thanks,

Sarif

I am attaching the Sample App.

22 Replies
sunny_talwar

The chart doesn't show it, but there is month 2 with value 0 in it... so the average is including Month 2 and Month 6

Capture.PNG

Does it make sense now .... When this is over I am holding you to mark unlimited helpful responses for me (JK)

Let me know if you have any other doubt....

mhmmd_srf
Creator II
Creator II
Author

Okk.. got it...

Thanks a lot for your time...and answer my silly questions..

Thanks Sunny...

sunny_talwar

No questions are silly my friend... I am glad I was able to help you...