Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
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

Conditional Layout on a Chart

Here is what my application shows:

ListBox one contains all the products we have. (Product1,Product2,Product3,etc)

ListBox two contains all the industries we serve. (Industry1, Industry2, Industry3, etc)

1. The first requirement is to have a chart like the one below which I have completed:

AcctNumber          OrganizationName               ProductName            

123                         Balls Store                              Product1

123                         Balls Store                              Product2

234                         Pales Store                             Product1

345                         Young Store                            Product1

345                         Young Store                            Product2

456                         Hall Store                                Product1

2.  The second requirement is to show the following:

AcctNumber          OrganizationName               ProductName            

234                         Pales Store                             Product1

456                         Hall Store                                Product1

The second chart are those Organizations that own Product 1 and not Product 2.  Now we can determine that from the first chart but have to send it to excel and filter items out.  What I was hoping is either put a Condition on the Layout of the chart or just highlight those Organizations in the first chart.  Is this possible and if so please assist. 

David

4 Replies
Not applicable

Re: Conditional Layout on a Chart

Hi David, if you add the Product List box to the Layout and if you select Product1 in the LB, the first chart automatically show Product1 list only. I don't think so you dont need another object.

nagaiank
Valued Contributor III

Re: Conditional Layout on a Chart

Did you try using And-Mode listbox?

An example is attached.

renuka_sasikumar
Contributor III

Re: Conditional Layout on a Chart

While creating chart you can also give the if condition in the Dimension such as selecting only

ProductName as Product1

Not applicable

Re: Conditional Layout on a Chart

I have not tried the and mode listbox.  I like the ldea but the problem is it gives me all of those clients with Product 1.  I only want those clients that own Product 1 and not Product 2.

David

Community Browser