topic Re: Combo Chart in QlikView

Combo Chart

subbareddykm — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 24 Mar 2017 09:09:46 GMT

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 — Fri, 24 Mar 2017 09:14:09 GMT

I tried that,but no luck.

please check attached file.

adamdavi3s — Fri, 24 Mar 2017 09:19:26 GMT

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 — Fri, 24 Mar 2017 09:35:25 GMT

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 — Fri, 24 Mar 2017 09:37:49 GMT

Just change it to be <= 1 in that case

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

adamdavi3s — Fri, 24 Mar 2017 09:39:57 GMT

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

subbareddykm — Fri, 24 Mar 2017 09:41:46 GMT

for which expression i should apply this in conditional hide.

if u dont mid can apply this in that file?

adamdavi3s — Fri, 24 Mar 2017 09:49:39 GMT

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.