Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

chinnukool
New Contributor III

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

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:

https://community.qlik.com/inbox?objectType=2&objectID=1014058

1 Solution

Accepted Solutions

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

3 Replies

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

chinnukool
New Contributor III

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

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!

chinnukool
New Contributor III

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

Hi Sunny,

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

Thanks!