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]

‌yes please..

[sunny_talwar · Accepted solution]

Can you check:

[Anonymous]

Thanks much!

One last thing, can you please help me write an expression for the below situation.

Display 1 text box when 2 alternate years data is available.

Thanks a lot for your time!

[sunny_talwar]

Can you share a sample where this is true?

[Anonymous]

Attached qvw to my original post.

[sunny_talwar]

The text box seems to show up, but the number isn't showing

[Anonymous]

I will check that.

Thanks again for all your help!

[Anonymous]

Hi Sunny,

I need your help with the same issue. I have attached the latest qvw to my original post.

Issue: For this firm 2014-2015 YOY% text box is overlapping with the bar and YOY% is not displayed for 2015-2016 YOY%. I tried to modify the expressions you wrote for conditional show but no luck.

Can you please look into this... Thanks!

[sunny_talwar]

Hopefully no more changes will be required. Check out the attached

[Anonymous]

Hopefully not

Thanks much for your quick reply!