Highlighting data in table in qliksense

[srujanaponnuru]

Hi All, 

I have the data below:

Vehicle ID	Vehicle Address Old	Vehicle Address New	Vehicle State Old	Vehicle State New	Email - Old	Email - New
1234	153 - Flat A	154 - Flat B	California	NewYork	stp@adp.com	stp1@adp.com
4567	152 - Flat C	152 - Flat C	California	California	stp@adp.com	stp@adp.com
7890	151 - R	156 - T	New Jersey	New York	pol@adp.com	pol1@adp.com
1221	151 - Y	151 - Y	Seattle	Seattle	pol@adp.com	pol@adp.com

On the above table, where the data is changing from Vehicle Address old to new i need to highlight either in bold or color to differentiate the other rows. For eg. Vehicle numer 1234 data is changing but Vehicle number 4567 , the data is not changing. so we dont need to highlight those rows. 

Please let me knpw how to do it in qliksense in a table without using extensions.

Regards,

S.

[kaushiknsolanki · Accepted solution]

Hi,

Create a table chart and add all this field as dimension.

Now Set the background c0lor expression as  If(Field1 = Field2, Black(), Red())

Regards,

Kaushik Solanki

[srujanaponnuru]

Thank you. Its working but the load time is taking too much time. Logic is working. only for one column i applied it took almost 20 mts to populate the data. Like that i have 50 columns.