Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vanand3535
Creator III
Creator III

Qlik Sense Set analysis expression issue

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

 

 

View solution in original post

3 Replies
Channa
Specialist III
Specialist III

it is like having clause in ur SQL

 

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

Channa
tresesco
MVP
MVP

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

 

 

View solution in original post

sunny_talwar

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

image.png