Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

Re: Qlik Sense Set analysis expression issue

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
Highlighted
Specialist III
Specialist III

Re: Qlik Sense Set analysis expression issue

it is like having clause in ur SQL

 

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

Channa
Highlighted
MVP
MVP

Re: Qlik Sense Set analysis expression issue

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

Highlighted

Re: Qlik Sense Set analysis expression issue

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

image.png