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

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

Thu, 26 Jun 2014 17:29:08 GMT

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"

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

vgutkovsky — Thu, 26 Jun 2014 18:19:40 GMT

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

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

Thu, 26 Jun 2014 18:21:42 GMT

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

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

Thu, 26 Jun 2014 18:22:54 GMT

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

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

vgutkovsky — Thu, 26 Jun 2014 18:26:19 GMT

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

Regards,

Vlad

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

Thu, 26 Jun 2014 20:42:43 GMT

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

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

Thu, 26 Jun 2014 21:15:08 GMT

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

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

vgutkovsky — Thu, 26 Jun 2014 21:48:29 GMT

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

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

Mon, 30 Jun 2014 14:38:20 GMT

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

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

vgutkovsky — Mon, 30 Jun 2014 18:12:27 GMT

Glad to hear it, and you're very welcome

Vlad