topic Re: Conditional Layout on a Chart in QlikView

Conditional Layout on a Chart

Fri, 16 May 2014 11:24:04 GMT

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

Re: Conditional Layout on a Chart

Sun, 18 May 2014 01:39:06 GMT

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.

Re: Conditional Layout on a Chart

nagaiank — Sun, 18 May 2014 03:50:46 GMT

Did you try using And-Mode listbox?

An example is attached.

Re: Conditional Layout on a Chart

renuka_sasikumar — Mon, 19 May 2014 09:08:43 GMT

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

ProductName as Product1

Re: Conditional Layout on a Chart

Mon, 19 May 2014 11:02:31 GMT

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