topic Re: Help with color change based on column values comparison in QlikView

Help with color change based on column values comparison

Tue, 04 Jun 2013 13:14:28 GMT

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?

Re: Help with color change based on column values comparison

Gysbert_Wassenaar — Tue, 04 Jun 2013 13:36:55 GMT

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.

Re: Help with color change based on column values comparison

Tue, 04 Jun 2013 14:36:09 GMT

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.