Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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).
it is like having clause in ur SQL
it will count CUSTOMER_SURRO_KEY where Count(Distinct INTERACTION_ID)>0
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).