Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Scan different fields value and compare based on User selection

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:

Customer1Customer2Customer3Customer4Customer5Customer6
BABBVB
CAVBBB
AVABBV
ACCACA
ABBCCC

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.

1 Reply
Not applicable
Author

UP.

any chance someone can help here?