Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Set Analysis Help

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.



1 Reply
Valued Contributor II

Re: Set Analysis Help

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!

Community Browser