Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following Plan profile but want to re-phase it equally over 12 months in a line chart to see how the plan profile differs from a straight line profile. Any ideas?
Thanks
Month | Plan Profile |
April | 12,341,768 |
May | 12,143,115 |
June | 12,767,261 |
July | 12,496,416 |
August | 12,467,133 |
September | 12,840,506 |
October | 12,940,018 |
November | 13,356,897 |
December | 13,061,811 |
January | 13,273,186 |
February | 12,942,857 |
March | 13,379,750 |
TOTAL | 154,010,718 |
Does it have to be a line chart, or could you add it as a reference line?
You could create a second expression...
sum( TOTAL Amount)/12
We have it in a line chart using excel at the moment. Am relatively new to Qlikview so don't know anything about reference lines. Can you please provide more detail
Thanks
Hi Trevor,
Maybe this?
See in App uploaded
Hope this helps, if not, please provid more info about your required output.
Regards,
MB
Hi Trevor,
What about this chart that shows deviation from the average?:
Kind regards
Andrew