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

[Anonymous]

Hi,

I have a bar chart displaying 3 years of data 2014,2015 and 2016. And YOY% are displayed between the bars in a text box.

Condition here is when there is data for all the 3 years then only text boxes has to be displayed.

See below screenshot

When data is there only for 1 or 2 years the text boxes should not be displayed.

To achieve this I wrote a conditional show statement under Layout 'count(DISTINCT(Year)) >2'. But this is not hiding the text boxes.

If you see in below screenshot, textboxes are overlapping with the bars.

Note: There are no year filters available in the dashboard

Can someone please help me hide these textboxes when 3 years of data is not available.

Thanks!

[Anonymous]

Hi Sunny,

I need your help, I have attached the latest qvw to my original post.

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 expressions you wrote for conditional show but no luck.

Can you please help me with this... Thanks!

[sunny_talwar]

I would suggest opening a new thread to get greater exposure for your requirement. You can link to this thread so that others can have a context for what you are looking for.

Best,

Sunny

[Anonymous]

sure.. will do that. Thanks!

[sunny_talwar]

Thanks