Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greetings, Qlik Aces!
I'm creating line chart to analyse values by month compared to previous year. Using trend line to see average value. So, the problem - when analysing current year, the average trend line is calculated by dividing summ of, for example, first two month / 12, no divided by two.
In my opinion the average trend line should be calculated based on month with value, not on total month count.
Any ideas how to solve this?
Thank you.
Have you tried calculating the average manually?
sum(Value)/count({$<Month={"=sum(Value)>0"}>} Month)
You would need to add whatever set analysis you are using to limit the time frame.