Getselectedcount for several field

[lessassy]

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]

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

[lessassy]

It doesn't work unfortunately 😕

[m_woolf]

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

[lessassy]

yes

[m_woolf]

The show condition is on the Layout tab.

[lessassy]

It's kind of working

Before

While:

After:

But everything is disappearing.

I would have like to keep this

[m_woolf]

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]

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