Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
AlexWest
Creator
Creator

Filter empty value

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 🙂

Labels (2)
15 Replies
Bunim
Contributor III
Contributor III

Show me the expression in the calculation condition

AlexWest
Creator
Creator
Author

Sure, here:

1.PNG

2.PNG

3.PNG

  

Bunim
Contributor III
Contributor III

and the filter data is Account_creation_date?

AlexWest
Creator
Creator
Author

=[Account_creation_date.autoCalendar.Year]

is it critical? )))

Bunim
Contributor III
Contributor III

you most put in the getselectededcount() the same field that you put in filter.

AlexWest
Creator
Creator
Author

I changed the value exactly like it is in the Filter's data, but nothing changed. The same message, that "Calculation conditions is not fullfilled."

AlexWest_0-1656578044305.png