Combo Chart

[subbareddykm]

Hi All i have combo chart for rolling 5 years,that is working fine.

One requirement i got from user is if he select three years only that three years data with select years labels only shd display.

For ref check below APP

[adamdavi3s]

You should be able to do this on the show condition using the wildmatch function to decide if it should show or not.

Kind regards

Adam

[subbareddykm]

I tried that,but no luck.

please check attached file.

[adamdavi3s]

See attached

Just use something like

if(GetSelectedCount(Year) =1 OR GetSelectedCount(Year) >=5,1,0)

if(GetSelectedCount(Year) =1 OR GetSelectedCount(Year) >=4,1,0)

if(GetSelectedCount(Year) =1 OR GetSelectedCount(Year) >=3,1,0)

etc.

[subbareddykm]

i m getting one more issue with your lgoic,

If i do not select any value in year,Its showing only current year.it shd show me years .

except this everything is fine.

[adamdavi3s]

Just change it to be <= 1 in that case

if(GetSelectedCount(Year) <=1 OR GetSelectedCount(Year) >=5,1,0)

[adamdavi3s]

Also just as an aside if you want to get your months to show in the correct order with no selections use this:

[subbareddykm]

for which expression i should apply this in conditional hide.

if u dont mid can apply this in that file?

[adamdavi3s · Accepted solution]

That goes on the sort tab.

Please see attached

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

This will help users identify the answers should they come across this thread in the future.