Set Analysis

[danieldors]

Hello,

I'm trying to count the number of Access Numbers when values for Unrun_Drivers =1 and Expedited=Y, currently it is only counting the Unrun_Drivers.

count({<Unrun_Drivers={'1'},expedited={'Y'}>}distinct [Access Number])

Thank you

[Or · Accepted solution]

I'm not sure if it's a typo in your post or in the original formula, but the set analysis reads expedited (lowercase 'e'( instead of Expedited (Uppercase 'E'). As ever, Qlik is case sensitive.

[danieldors]

Thank you that fixed it.