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: 
Not applicable

Calculation condition statement not working

I'm using a calculation condition to control a chart trend line. I want to have the user select at least one Specialty team from the multi box for the chart to show a trend. I am using the statement  if(count(distinct(DaysFilled.Specialty))>0,1,0)  then I display a error message to select at least one specialty team. It works when I go into it originally is set to zero, but when I use the Clear Selections button it deflauts back to DaysFilled.Specialty all selections. I want it to go back to the Error message of you have to make at least one selection.

Help please!

Thank you in advance.

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hei replace your expression with this one  getselectedcount(DaysFilled.Specialty)>0

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hei replace your expression with this one  getselectedcount(DaysFilled.Specialty)>0

Not applicable
Author

Thank you Thank you Thank you