topic Calculation condition statement not working in QlikView https://community.qlik.com/t5/QlikView/Calculation-condition-statement-not-working/m-p/277092#M103322 <HTML><HEAD></HEAD><BODY><P> Thank you Thank you Thank you</P></BODY></HTML> Wed, 26 Oct 2011 15:13:18 GMT 2011-10-26T15:13:18Z Calculation condition statement not working https://community.qlik.com/t5/QlikView/Calculation-condition-statement-not-working/m-p/277090#M103320 <HTML><HEAD></HEAD><BODY><P>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&nbsp; if(count(distinct(DaysFilled.Specialty))&gt;0,1,0)&nbsp; 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. </P><P></P><P>Help please!</P><P></P><P>Thank you in advance.</P></BODY></HTML> Wed, 26 Oct 2011 14:35:07 GMT https://community.qlik.com/t5/QlikView/Calculation-condition-statement-not-working/m-p/277090#M103320 2011-10-26T14:35:07Z Calculation condition statement not working https://community.qlik.com/t5/QlikView/Calculation-condition-statement-not-working/m-p/277091#M103321 <HTML><HEAD></HEAD><BODY><P>hei replace your expression with this one&nbsp; getselectedcount(DaysFilled.Specialty)&gt;0</P></BODY></HTML> Wed, 26 Oct 2011 14:53:43 GMT https://community.qlik.com/t5/QlikView/Calculation-condition-statement-not-working/m-p/277091#M103321 lironbaram 2011-10-26T14:53:43Z Calculation condition statement not working https://community.qlik.com/t5/QlikView/Calculation-condition-statement-not-working/m-p/277092#M103322 <HTML><HEAD></HEAD><BODY><P> Thank you Thank you Thank you</P></BODY></HTML> Wed, 26 Oct 2011 15:13:18 GMT https://community.qlik.com/t5/QlikView/Calculation-condition-statement-not-working/m-p/277092#M103322 2011-10-26T15:13:18Z