Scan different fields value and compare based on User selection

Tue, 23 Jun 2015 17:46:35 GMT

Hello,

I tried to look for this question in different threads and couldn't find the answer. maybe someone here can help

Basically, I have 6 columns table with different values inside that can repeat in all of the columns,

I want to give the user the option to select a combination of columns, then present only the lines where the cells values in those columns are match to each other.

for example:

Customer1	Customer2	Customer3	Customer4	Customer5	Customer6
B	A	B	B	V	B
C	A	V	B	B	B
A	V	A	B	B	V
A	C	C	A	C	A
A	B	B	C	C	C

The user can select which customer he wants to compare -

If the user select Customer1+Customer4+Customer6 the only lines that will appear are lines 1 and 4 (marked as red).

I've tried to work with variables that gets populate with the Column name based on the selection, then creating calculated dimension that compare the values, but it's too complicated (there are more than 60 permutations), and the performance in case of many lines is poor.

Will glad to hear your thoughts.

Thank you for helping!!

Shahar.

Re: Scan different fields value and compare based on User selection

Wed, 24 Jun 2015 13:05:57 GMT

UP.

any chance someone can help here?

topic Re: Scan different fields value and compare based on User selection in QlikView

Scan different fields value and compare based on User selection

Re: Scan different fields value and compare based on User selection