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

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

Mon, 05 Sep 2016 12:33:52 GMT

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

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

c_gilbert — Mon, 05 Sep 2016 15:30:50 GMT

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

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

Anonymous — Mon, 05 Sep 2016 15:42:24 GMT

You could create a second expression...

sum( TOTAL Amount)/12

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

Mon, 05 Sep 2016 15:43:53 GMT

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

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

miguelbraga — Mon, 05 Sep 2016 15:45:48 GMT

Hi Trevor,

Maybe this?

See in App uploaded

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

Regards,

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

effinty2112 — Mon, 05 Sep 2016 15:50:47 GMT

Hi Trevor,

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

Kind regards

Andrew