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

How can I re-distribute a monthly plan in equal 1/12ths in a line chart?

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

   

MonthPlan Profile
April12,341,768
May12,143,115
June12,767,261
July12,496,416
August12,467,133
September12,840,506
October12,940,018
November13,356,897
December13,061,811
January13,273,186
February12,942,857
March13,379,750
TOTAL154,010,718
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

You could create a second expression...

sum( TOTAL Amount)/12

View solution in original post

5 Replies
c_gilbert
Creator II
Creator II

Does it have to be a line chart, or could you add it as a reference line?

Anonymous
Not applicable
Author

You could create a second expression...

sum( TOTAL Amount)/12

Not applicable
Author

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

miguelbraga
Partner - Specialist III
Partner - Specialist III

Hi Trevor,

Maybe this?

See in App uploaded

Hope this helps, if not, please provid more info about your required output.

Regards,

MB

effinty2112
Master
Master

Hi Trevor,

What about this chart that shows deviation from the average?:

Chart.JPG

Kind regards

Andrew