topic Re: YOY Not working when single year is selected in QlikView

YOY Not working when single year is selected

avinashkk696 — Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

I have a requirement in which I have to show a bar chart in which, One bar shows the Current Year value and second bar will show the previous year value. My dimension is Year and expression-1 is Sum(Sales) and expression - 2 is Sum(Sales). Minimum Year is 2013, Max is 2017. When 2014 or any year other than 2013 is selected, chart is not displaying any value for previous year.

When no year is selected:

When a Year is selected,

Re: YOY Not working when single year is selected

sunny_talwar — Wed, 26 Apr 2017 18:19:12 GMT

What is your expression for Previous Year?

Re: YOY Not working when single year is selected

sunny_talwar — Wed, 26 Apr 2017 18:20:32 GMT

Assuming you have something like this

Above(Sum(Sales)), change it to this

Above(Sum({<Year>} Sales)) * Avg(1)

Re: YOY Not working when single year is selected

avinashkk696 — Thu, 27 Apr 2017 04:46:51 GMT

Hello Sunny,

Sorry for the mistake. My Second expression is Above(Sum(Sales)).

Re: YOY Not working when single year is selected

sunny_talwar — Thu, 27 Apr 2017 09:20:59 GMT

Did you try this?

Above(Sum({<Year>} Sales)) * Avg(1)