topic Re: Bar Chart Trendline in QlikView

Bar Chart Trendline

Wed, 15 Jul 2015 11:56:27 GMT

Just wondering if anyone can help me I am looking to create a bar chart showing month on month a trendline showing a percentage increase or decrease from month to month for each year.

It's the figure Income/Accounts from the Excel attachment that I am trying to get the trendline on if anyone can advise me.

Re: Bar Chart Trendline

qlikmsg4u — Wed, 15 Jul 2015 12:14:37 GMT

Hi Sue,

This is what your are looking for?

Re: Bar Chart Trendline

Wed, 15 Jul 2015 13:05:41 GMT

Hi thanks for the reply,

Unfortunately I am only using the personal edition is their anyway you could put it in here what you done if you could.

Thanks again for your reply.

Re: Bar Chart Trendline

awhitfield — Wed, 15 Jul 2015 14:51:21 GMT

Hi Sue,

this is the chart;

Chart = Combo

Dimension = YearMonth

Bar Expression = Sum([Income/Accounts]) , with values on Data Points

Line Expression = sum([Income/Accounts]) / Above(sum([Income/Accounts])) -1

HTH - Andy

Re: Bar Chart Trendline

Wed, 15 Jul 2015 15:09:35 GMT

Hi Andrew,

I have the chart with the values on top but my line is not giving me the percentage difference it is probably something I am forgetting to do.

Re: Bar Chart Trendline

awhitfield — Wed, 15 Jul 2015 15:21:06 GMT

No problem line expression has Value on data point too:

Missed that bit!

Andy