Filter empty value

[AlexWest]

Hi colleagues, 

Please help with Filter codes.
I need to do a filter pane check:
If Filter is not chosen, show sum on Key pane.
I mean, I have filter with dates (years and days). 

And I have a Key pane with Clients sum.
And i can't make that if filter is not chosen, Key pane must show “-” symbol, or something like “chose a period”. 

Please help to realize the code.
Thanks a lot 🙂

[Bunim]

Add-ons -> Calculation condition

[AlexWest]

Sorry, what? 😅
Could you please explain a little in details? 

I'm a newbie in this system 😅😅

[Bunim]

in Calculation condition write

if(GetSelectedCount(dates )>0,1,0)

[AlexWest]

Wow, man! Thanks a lot! Tomorrow will try and come back with feedback)

[AlexWest]

Hi!

Unfortunately, this way didn't help(

I wrote in Add-Ons - if(GetSelectedCount(Account_creation_date)>0,'y','n') 

But nothing happened(

I'll attach the picture how do I have it.

 

 

  

[Rajashekar]

hi @AlexWest 

write 1 and 0 instead of Y and N.

 if(GetSelectedCount(Account_creation_date)>0,1,0) 

1 -show

0 - hide.

you can write default text when metric is hidden. 

[AlexWest]

Hi @Rajashekar 

Yeah, your advice is working, but it works as by default): if I select 21y - the pane shows one argument, if 22y - another one arg. And if nothing's selected - the pane shows all the SUM.

But I need to hide any text if filter is not selected.

[Bunim]

Hi @AlexWest 

The SUM put in Data filed expression not in Data handling.

in Data handling Displayed message write "Please select Account Creation_date".

Cheers,

[AlexWest]

I made exactly like you advised, but now Displayed message is showing all the time.

Then I tried to remove Displayed message, and now the pane's showing message "The calculcation condition is not fullfilled", whatever I'd select.