Noob question related to getfieldselections

[toddbuss]

I'm putting conditional logic based on which fields are selected. 

Can anyone tell me why the first condition below ='ALL' works, but the second condition ='-' does not?

if(getfieldselections(SGradeInitialValue)='ALL',1/total_population,

//condition is positive when all are selected

if(getfieldselections(SGradeInitialValue)='-',1/total_population,

//condition should be positive when none are selected

Thanks.

[sunny_talwar · Accepted solution]

May be try this:

if(Len(Trim(getfieldselections(SGradeInitialValue))) = 0, 1/total_population,

[toddbuss]

Thanks.  Worked like a charm.

The quirkiness of the Qlik syntax continually baffles me.