background color for when any date is not in sequence

[#1]

Hello Friends,

i want to change background color for date fields when date is not in sequence ,

for example when date sequence like

05-04-2017

05-04-2017

05-04-2017

06-04-2017

05-04-2017

05-04-2017

in this i want to change background color of date when sequence is change,i,e different date is coming in between date.

for clear under standing i attached sample data.desired out put also is same sample data file.

[MK_QSL]

But in which object you want to show this?

[Anil_Babu_Samineni]

Here, I didn't understand this, There is no date changed how and why you want to change BG color for that. Would you share more on this

[#4]

Hi,

In straight table

[#5]

Hi anil,

Please check column wise.

[Anil_Babu_Samineni]

Yes, I have check that too.

In Qlikview, For acc_date i got like below

[#7]

Please check it date is changes in red colour background date is different

[#8]

Date format is dd-mm-yyy

[Anil_Babu_Samineni]

I am sorry, May be someone else helps to you

[MK_QSL]

Anil's question is valid and genuine.

What is the logic behind red color date?

for a4202 body_date 04/04/2017.. Why this is having red color.

You need to explain proper logic!