topic Re: Conditional display of YOY% in text boxes based on the number of years in a bar chart in QlikView

Conditional display of YOY% in text boxes based on the number of years in a bar chart

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

Hi,

I need help in displaying YOY% in a bar chart based on number of years. I have attached my qvw.

I have a bar chart displaying 4 years of data 2014,2015,2016 Outlook and 2016. And YOY% is displayed between the bars in text boxes.

YOY% has to be displayed based on below conditions

1. If we have all 4years(2014,2015,2016 Outlook and 2016) of data, display YOY% between 2014 - 2015 and 2015 - 2016 outlook

2. If we have 3years(2014,2015 and 2016) of data, display YOY% between 2014 - 2015 and 2015 - 2016

3. If we have 2years(2014 and 2016) of data, display YOY% between 2014 and 2016

4. If we have 2years(2014 and 2015) of data, display YOY% between 2014 and 2015

5. If we have 2years(2015 and 2016) of data, display YOY% between 2015 and 2016

6. If we have 2years(2015 and 2016 outlook) of data, display YOY% between 2015 and 2016 Outlook

7. If we have just 1year data, YOY% should not be displayed

Issue: YOY% is not being displayed right when it shows 3years or 2years of data

I tried to modify the expression which is working for 4Years but no luck.

Can someone please help me with this asap... Thanks!

Previous Discussion on this:

sunny_talwar — Tue, 28 Jun 2016 14:56:13 GMT

Anonymous — Tue, 28 Jun 2016 15:25:54 GMT

The logic used in conditional show in the above mentioned thread is not working as expected.

I would really appreciate if you can help me fix this.

Thanks!

Anonymous — Thu, 14 Jul 2016 15:50:19 GMT

Hi Sunny,

Can you please take a look at this issue for me?

Thanks!