Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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