Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
rdsuperlike
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?

Labels (1)
1 Reply
sunny_talwar
MVP
MVP

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