Help with color change based on column values comparison
Hello All,
I am new to QlikView and working on my first assignment. I need help with the following:
I have a table with fields - Date, Company, First Name, Last Name, Email. Now, I have a second table which also has First Name and Last Name and few other fields. What I want to do is if the first Name and Last Name from second table match to that in first then mark those entries in table one (first table) in a different color. What will be the best way to achieve this?
Best is to associate the two tables in the script on a key based on the first and last name. It does work without, but then you get a cartesion product. You can use an expression to calculate a color. Click on the + in front of a dimension and select Background Color. See attached example.
Best is to associate the two tables in the script on a key based on the first and last name. It does work without, but then you get a cartesion product. You can use an expression to calculate a color. Click on the + in front of a dimension and select Background Color. See attached example.
Thank you very much. This works for me with small data but with the number of records I have I am running out of object memory. Is there a solution for that ? I am planning on using inner join and then just displaying the result in a table. I would have preferred the color difference as it is better for visual effect.
