Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted

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....