Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

background color for when any date is not in sequence

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.

14 Replies
Not applicable
Author

Hi manish,

For a4202 body it is by mistake background colour is wrong.sorry for this because it is sample data.

Sorry for inconvenience.

saimahasan
Partner - Creator III
Partner - Creator III

Hi

Can this help you.

PFA

MK_QSL
MVP
MVP

Can you update the excel and reattached it here?

Not applicable
Author

   hi manish,

here i paste the data and mark as bold  for background colour.

  

idbodyaccacc_datebody_datefinal_date
a146btc170514579205-04-201705-04-201705-04-2017
a458btc170614879405-04-201705-04-201706-04-2017
a770btc170714879506-04-201705-04-201705-04-2017
a1082btc1708150796.705-04-201705-04-201705-04-2017
a1394btc1709152298.205-04-201705-04-201705-04-2017
a1706btc1710153799.705-04-201705-04-201705-04-2017
a2018btc1711155301.207-04-201707-04-201707-04-2017
a2330btc1712156802.707-04-201709-04-201707-04-2017
a2642btc1713158304.207-04-201707-04-201707-04-2017
a2954btc1714159805.708-04-201707-04-201707-04-2017
a3266btc1715161307.207-04-201707-04-201707-04-2017
a3578btc1716162808.704-04-201704-04-201704-04-2017
a3890btc1717164310.204-04-201704-04-201705-04-2017
a4202btc1718165811.704-04-201705-04-201704-04-2017
a4514btc1719167313.204-04-201704-04-201704-04-2017
a4826btc1720168814.704-04-201704-04-201704-04-2017
a5138btc1721170316.206-07-201704-04-201704-07-2017
a5450btc1722171817.704-04-201704-04-201704-04-2017
a5762btc1723173319.204-04-201704-04-201704-04-2017
Kushal_Chawda

looks like some of the entry in date is wrong.