topic Re: Getselectedcount for several field in QlikView

Getselectedcount for several field

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

Hello everyone,

I want to use the formula if(GetselectedCount(WeekYear) ,1,0) on several fields which are:

The main objective is to display a chart if one of the field (Month, Year, Quarter....) are selected

From now i could only have put a field in the formula.

I tried this: if((GetselectedCount(WeekYear) ,1,0) or (GetselectedCount(Year) ,1,0) or GetselectedCount(Month) ,1,0))

But it doesn't work.

Anyone can help ?

thank you in advande

m_woolf — Fri, 18 May 2018 17:04:53 GMT

(GetselectedCount(WeekYear)>0 or (GetselectedCount(Year)>0 or GetselectedCount(Month)>0

lessassy — Fri, 18 May 2018 17:07:49 GMT

It doesn't work unfortunately 😕

m_woolf — Fri, 18 May 2018 17:13:52 GMT

Are you putting that in the Chart's Show Condition?

lessassy — Fri, 18 May 2018 17:19:46 GMT

yes

m_woolf — Fri, 18 May 2018 17:27:20 GMT

The show condition is on the Layout tab.

lessassy — Fri, 18 May 2018 17:45:59 GMT

It's kind of working

Before

While:

After:

But everything is disappearing.

I would have like to keep this

m_woolf — Fri, 18 May 2018 19:16:13 GMT

You can create a text box with that info or image in it. You might add a message in the text box that says something like:

"Select a Date to view the chart"

Put the textbox under the chart.

MarcoWedel — Fri, 18 May 2018 20:05:04 GMT

GetselectedCount(WeekYear) or GetselectedCount(Year) or GetselectedCount(Month)