Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Correct link is this: Conditional display of 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!
Hi Sunny,
Can you please take a look at this issue for me?
Thanks!