Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 

Set analysis question

(count({< [TYPE],[ REASON],[GRP] = >} (if([JOB ]<> 'DIRECT', EMPNUM))))/2

I am trying to understand what does {< [TYPE],[ REASON],[GRP] = >} part mean in above expression. Is it used for counting distinct of all 3 combination? no value after = means?

1 Reply

Those means that you are just ignoring any direct selection made in those fields for this expression. I would also remove the id statement and make this the expression:

Count({<[TYPE],[ REASON],[GRP], JOB -= {'DIRECT'}>} EMPNUM)/2

Note the red negative sign in front of the equal sign after JOB field....