Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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?

1 Reply
sunny_talwar

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