Change in ID when compared with prev date

[renjithpl]

Hi All,

I have a table like below

Date	Col1	Col2
26/04/2014	AA1	OK
27/04/2014	AA1	OK
28/04/2014	AA2	OK
29/04/2014	AA2	Test
30/04/2014	AA2	OK

I need to highlight Col1 if there is any change in Col2 when compared with previous date.

Here in eg. Col1 = AA2 has "OK" on 30/04/2014 and has  "Test" on 29/04/2014.

I need to highlight AA2 in 30/04/2014.

Cheers

Ren

[tresesco]

May be like attached qvw?

[renjithpl]

I cant use above function..

[tresesco]

Why so?

[renjithpl]

I wont be using month/Date as dimension in the chart. I am looking something we can achieve using Set Analysis.

It takes the max(Date) and Max(Date)-1 and compares the Col2, if not equal then highlight them.

[#6]

Can you do this in your load script?  Order by date and use the PEEK function to review the prior row

[#7]

Please try this

[tresesco]

Could you share your sample qvw?