Set Analysis Help

Wed, 28 May 2014 14:06:41 GMT

I have attached a copy of my Prototype App and the Source File. What you will see is two list boxes and a chart listing. What I want to accomplish is create a second chart listing for up sells. I am going to use ProductCode = MD as my base. With that said in the second chart my up sells would be everyone except for Org 1, Org 5, and Org 8 because they already own ProductCode = MD and ITD.

I am not sure how to handle this since the list boxes control what you see and I need to have both charts. Is this something I could do with an Input Box or Alternate State? I have been researching ideas but have not come across anything yet.

Thanks,

David

Re: Set Analysis Help

jerem1234 — Wed, 28 May 2014 14:26:15 GMT

Can you be more specific to what you want displaying in your second chart according to your selections? You can use calculated dimensions like:

=aggr(only({<OrganizationName = {"=count(distinct ProductCode)<=1 and ProductCode = 'MD'"}>}OrganizationName), OrganizationName)

to reduce what organizations will be popping up. You may also move the set analysis into any expressions you are using. But I am not sure exactly what you want to be achieved.

Hope this helps!

topic Re: Set Analysis Help in QlikView

Set Analysis Help

Re: Set Analysis Help