topic Re: compare listbox value in QlikView

compare listbox value

omid5ive — Sat, 22 Dec 2012 05:31:48 GMT

i have two list box with this value:

first listbox=A,B,C,D

2nd listbox=B,C,E

i want to have third list box with the value of diffrence from first and second listbox

third listbox=A,D

how can i fix this problem?

Gysbert_Wassenaar — Sat, 22 Dec 2012 11:06:42 GMT

It's not quite clear to me what you want. See attached qvw. It has two approaches, one using alternate states and one using three fields.

omid5ive — Sat, 22 Dec 2012 11:12:49 GMT

thank you

but i want to have list box with diffrece between first and second table

for example:

in first table we have this values : A,B,C,D

in 2nd table we have this values: B,C,D,E

i want joint value

B,C,D

Anonymous — Mon, 27 Oct 2014 13:45:22 GMT

I have the same question.

In SQL this can be done by UNION [ALL], INTERSECT, MINUS.

Having two listboxes, 'the result' of the two fields should be calculated dynamically.

Eg:

F1: A, D

F2: B, D

F3(UNION): A,B,D

F3(INTERSECT): D

F3(F1 MINUS F2): A

Any idea ?