Qlik Sense Set analysis expression issue

[vanand3535]

Hi All,

I have a Qlik Sense set expression which is mentioned below:-

Count({<CUSTOMER_SURRO_KEY={'=Count(Distinct INTERACTION_ID)>0'}>} Distinct CUSTOMER_SURRO_KEY)

I'm not sure what this part is doing and how it's working in the background?

CUSTOMER_SURRO_KEY={'=Count(Distinct INTERACTION_ID)>0'

If someone has any idea about the working of this part then please let me know?

Thanks in advance.

Thanks,

Vivek Anand

[Channa]

it is like having clause in ur SQL

it will count CUSTOMER_SURRO_KEY where Count(Distinct INTERACTION_ID)>0

[tresesco · Accepted solution]

This is called 'advanced search in set analysis'. Here your '=Count(Distinct INTERACTION_ID)>0' is a search string. That means this part will filter CUSTOMER_SURRO_KEY for current selection,  only keys that has at least 1 interaction (more than 0).

[sunny_talwar]

Look at @hic response (01-10-2018 / 08:38 AM) Here