topic Re: YoY Analysis in Bar Chart in QlikView

YoY Analysis in Bar Chart

Anonymous — Tue, 18 Apr 2017 13:08:21 GMT

I have a field called Opp Create Year

I want to make a bar chart that shows a bar for $$ each month in 2017, with another bar next to each month for the same period in 2016

I put a sample below of what I was able to put together. I have two expressions in the chart:

=sum({<[Upsell ARR (converted)]={">0"}, [Opp Created Year] = {'2017'}>}[Upsell ARR (converted)])

=sum({<[Upsell ARR (converted)]={">0"}, [Opp Created Year] = {'2016'}>}[Upsell ARR (converted)])

I am close but this is not what I want. I would like to see the January 2016 bar next to the January 2017 bar and so on ..

Any help is appreciated!

Re: YoY Analysis in Bar Chart

tresB — Tue, 18 Apr 2017 13:15:12 GMT

May be sort it by Month field.

Re: YoY Analysis in Bar Chart

Anonymous — Tue, 18 Apr 2017 14:08:41 GMT

Didnt work. Thank you though

Re: YoY Analysis in Bar Chart

Or — Tue, 18 Apr 2017 14:17:22 GMT

In order for this to work, you would need to use month numbers/names (not month-year) for your dimension - you can get this value by using the Month() function.

Re: YoY Analysis in Bar Chart

Anonymous — Tue, 18 Apr 2017 15:20:25 GMT

Good catch! Thank you very much