Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Question with set theory – Count distinct customers across multiple transactions selected in dynamic list box.

Question with set theory – Count distinct customers across multiple transactions selected in list box.

My data is transactional. In the table “Test: I am trying to get the unique customers across the two rows. So males with some education.

Reponse is actually a combination of two fields Lable & Response

I was trying something like this count(disinct ({p(Response)>} Member_id)

This is a list box Response (It is one field)


Some High School     100

Male                         50

So I want a table that calculates unique customer id for the intersection of  "males" and "Some High School"

1 Solution

Accepted Solutions
vgutkovsky
Master II
Master II

Check out my last post here, should do what you need: http://community.qlik.com/thread/62060

Regards,

Vlad

View solution in original post

9 Replies
vgutkovsky
Master II
Master II

You just need to combine the 2 via set multiplication: count({<Member_id=P({<Reponse={'Male'}>} Member_id)>*<Member_id=P({<Reponse={'Some High School'}>} Member_id)>}distinct Member_id)

Regards,

Vlad

Not applicable
Author

I need it to be dynamic it won’t be Male or High School every time. There are many choices.

Trich Schultz, Analytic Marketing Innovations

(Tel) 913.897.9473 (Cell) 913.526.6743

trich.schultz@analyticmarketinginnovations.com<mailto:trich.schultz@analyticmarketinginnovations.com>

<http://www.analyticmarketinginnovations.com/>

<http://www.facebook.com/pages/Analytic-Marketing-Innovations-Inc/433411593362570>[cid:image003.jpg@01CF9141.7AA502D0]<https://www.linkedin.com/company/2711954?trk=tyah>[cid:image004.jpg@01CF9141.7AA502D0]<http://www.analyticmarketinginnovations.com/blog/>

Not applicable
Author

Thanks for the input! I really appreciate it.

Trich Schultz, Analytic Marketing Innovations

(Tel) 913.897.9473 (Cell) 913.526.6743

trich.schultz@analyticmarketinginnovations.com<mailto:trich.schultz@analyticmarketinginnovations.com>

<http://www.analyticmarketinginnovations.com/>

<http://www.facebook.com/pages/Analytic-Marketing-Innovations-Inc/433411593362570>[cid:image003.jpg@01CF9141.A01ADAD0]<https://www.linkedin.com/company/2711954?trk=tyah>[cid:image004.jpg@01CF9141.A01ADAD0]<http://www.analyticmarketinginnovations.com/blog/>

vgutkovsky
Master II
Master II

Check out my last post here, should do what you need: http://community.qlik.com/thread/62060

Regards,

Vlad

Not applicable
Author

That is smoking. Let me try it out.

Trich Schultz, Analytic Marketing Innovations

(Tel) 913.897.9473 (Cell) 913.526.6743

trich.schultz@analyticmarketinginnovations.com<mailto:trich.schultz@analyticmarketinginnovations.com>

<http://www.analyticmarketinginnovations.com/>

<http://www.facebook.com/pages/Analytic-Marketing-Innovations-Inc/433411593362570>[cid:image003.jpg@01CF9155.3292C180]<https://www.linkedin.com/company/2711954?trk=tyah>[cid:image004.jpg@01CF9155.3292C180]<http://www.analyticmarketinginnovations.com/blog/>

Not applicable
Author

So thanks so much for your help, but how do I sync the Reponse and AndResponse selections or do they have to be separate. This is a drill down hierarchy.

Trich Schultz, Analytic Marketing Innovations

(Tel) 913.897.9473 (Cell) 913.526.6743

trich.schultz@analyticmarketinginnovations.com<mailto:trich.schultz@analyticmarketinginnovations.com>

<http://www.analyticmarketinginnovations.com/>

<http://www.facebook.com/pages/Analytic-Marketing-Innovations-Inc/433411593362570>[cid:image004.jpg@01CF9159.B1398F10]<https://www.linkedin.com/company/2711954?trk=tyah>[cid:image005.jpg@01CF9159.B1398F10]<http://www.analyticmarketinginnovations.com/blog/>

vgutkovsky
Master II
Master II

I think you might be looking at someone else's comment or at the original post. My solution is at the very end (last comment as of now) and doesn't require any data model changes.

Vlad

Not applicable
Author

Thank you so much. Your sample worked perfectly and was very easy to implement. You are AweSome.

Trich Schultz, Analytic Marketing Innovations

(Tel) 913.897.9473 (Cell) 913.526.6743

trich.schultz@analyticmarketinginnovations.com<mailto:trich.schultz@analyticmarketinginnovations.com>

<http://www.analyticmarketinginnovations.com/>

<http://www.facebook.com/pages/Analytic-Marketing-Innovations-Inc/433411593362570>[cid:image003.jpg@01CF9446.EF31E5C0]<https://www.linkedin.com/company/2711954?trk=tyah>[cid:image004.jpg@01CF9446.EF31E5C0]<http://www.analyticmarketinginnovations.com/blog/>

vgutkovsky
Master II
Master II

Glad to hear it, and you're very welcome

Vlad