topic Change in ID when compared with prev date in QlikView

Change in ID when compared with prev date

renjithpl — Tue, 20 May 2014 09:37:43 GMT

Hi All,

I have a table like below

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

tresB — Tue, 20 May 2014 09:46:20 GMT

May be like attached qvw?

renjithpl — Tue, 20 May 2014 09:53:19 GMT

I cant use above function..

tresB — Tue, 20 May 2014 09:54:36 GMT

Why so?

renjithpl — Tue, 20 May 2014 10:04:26 GMT

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.

Tue, 20 May 2014 10:05:35 GMT

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

Tue, 20 May 2014 10:28:56 GMT

Please try this

tresB — Tue, 20 May 2014 11:08:50 GMT

Could you share your sample qvw?