topic Listbox selection in QlikView

Listbox selection

Tue, 03 Dec 2013 13:36:29 GMT

Hi,

i have following table.

Client Kennzahl1 Kennzahl2 Kennzahl3

A 10 40 50

B 25 35 45

C 50 70 35

Now, i want build two listboxes in qlikview. The first is selection on the field Client so this is easy but now i want to make a selection on Kennzahl1, Kennzahl2 and Kennzahl3. Is there any opportunity to make this row (Kennzahl1, Kennzahl2, Kennzahl3) available for selection in an list box.

In QlikView there must be 2 listboxes like this:

Client Kennzahlen

A Kennzahl1

B Kennzahl2

C Kennzahl3

I would be very happy if anyone knows something to build such selection.

Thanks and regards,

Thomas

Re: Listbox selection

tresB — Tue, 03 Dec 2013 13:42:21 GMT

Use crosstable like:

CrossTable (Kennzah, Amount, 1) Load *;

Load * Inline [

Client, Kennzahl1, Kennzahl2, Kennzahl3

A, 10, 40, 50

B, 25, 35, 45

C, 50, 70, 35

]

PFA

Re: Listbox selection

bbi_mba_76 — Tue, 03 Dec 2013 13:43:02 GMT

Hi,

maybe you can use the crosstable, so you have 2 dimension (Client, Kennzahl) and a measure (Data)

Crosstable (Kennzahl, Data)

LOAD * INLINE [

Client, Kennzahl1, Kennzahl2, Kennzahl3

A, 10, 40, 50

B, 25, 35, 45

C, 50, 70, 35

];

Re: Listbox selection

Tue, 03 Dec 2013 13:43:12 GMT

Thomas,

Are kennZahlen dimension or measure ?

If dimension, you should see crosstable keyword when loading your table

You will get 2 dimensions: Client, KennZahlen

and 1 measure that you will have to name.

Fabrice

Re: Listbox selection

Tue, 03 Dec 2013 15:32:50 GMT

Okay thank you. But now i have 3 excel sheets which have the same tables.

(Table Client A) (This table shows distances between A -> B,C)

Client, Kennzahl1, Kennzahl2, Kennzahl3

A, 0, 0, 0

B, 25, 35, 45

C, 50, 70, 35

(Table Client B) (This table shows distances between B -> A,C)

Client, Kennzahl1, Kennzahl2, Kennzahl3

A, 20, 30, 40

B, 0, 0, 0

C, 50, 70, 35

(Table Client C) (This table shows distances between C -> A,B)

Client, Kennzahl1, Kennzahl2, Kennzahl3

A, 40, 40, 40

B, 10, 10, 40

C, 0, 0, 0

Every month, there are new tablets created from a Java programm which will write the results into a excel csv sheet! This programm measures Distances between Clients and create for ever client one table.

Now Qlik View should show the results in a digramm but with reference to the selection!

1.Listbox A, B, C (Clients)

2.Listbox: A,B,C (Clients)

3.Listbox: Kennzahl1, Kennzahl2, Kennzahl3

Example 1 :

1.Listbox: Selection A

2.Listbox: Selection B,C

3.Listbox Selection Kennzahl1, Kennzahl2

Here i want to see how similar are B, C (2.Listbox) regarding to A (1.Listbox) with reference to Kennzahl1 and Kennzahl2 (3.Listbox)

Example 2 :

1.Listbox:Selection B

2.Listbox: Selection A,C

3.Listbox: Selection Kennzahl1, Kennzahl2, Kennzahl3

I hope you understand what i mean and i hope that anyone got and idea how it could work. Maybe there is a solution which is completely different from my idea?

Thanks,

Thomas