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

[#1]

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"

[vgutkovsky]

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

[#3]

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/>

[#4]

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 · Accepted solution]

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

Regards,

Vlad

[#6]

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/>

[#7]

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]

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

[#9]

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]

Glad to hear it, and you're very welcome

Vlad