topic Re: Diagram: Several inputs in one Dimension in QlikView

Diagram: Several inputs in one Dimension

Wed, 21 Aug 2013 12:29:06 GMT

Dear Community,

I have the following issue and would be very thankful if someone could help me:

I'd like to get a bar diagramm with companies as dimension and the corresponding revenue as expression.

BUT, I have two listboxes:

Listbox 1:

Company A

Company B

Company C

...

Listbox 2:

Company A

Company B

Company C

...

So the listboxes contain the same data, but in Listbox 1 only ONE value can be selected whereas in Listbox 2 several values can be selected. So the chosen value in Listbox 1 is supposed to be a kind of a "benchmark-partner" for all the other companies.

How can I create a diagram where the selected company of Listbox 1 is always shown as first bar, whereas the revenues of the selected companies of Listbox 2 is shown as the following bars after this "benchmark-partner".

Thank you very much!

Re: Diagram: Several inputs in one Dimension

richard_pearce6 — Wed, 21 Aug 2013 14:27:30 GMT

Try this example

Re: Diagram: Several inputs in one Dimension

Wed, 21 Aug 2013 15:08:28 GMT

Hi Richard,

thanks a lot! This is quite what I was looking for... But could I improve this diagram also in that way, that the benchmark is always shown on its own. Because in this example I can choose Company A in both listboxes, so that two bars are shown for Company A..?

Re: Re: Diagram: Several inputs in one Dimension

richard_pearce6 — Wed, 21 Aug 2013 15:47:05 GMT

Hi,

If I understand correctly I've attached a re-worked version. This has variables SET in the script which will remove a company from "Company_LB" if its been selected twice creating a new value which can be used in the set analysis.

Rich

Re: Diagram: Several inputs in one Dimension

Thu, 22 Aug 2013 09:00:28 GMT

Thanks a lot, Richard. It is exactly what I was looking for!

Now I have a similar question for another chart, maybe you can have a look at this as well:

http://community.qlik.com/thread/89886