Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to color New & Updated records


Hi All,

I want to color newly added & updated records. In dashboard suppose there are 20 records & when i

reload 2nd time then there are 25 records so i want to color newly added 5 records &  updated records

in existing if any? How to achive it?

Thanks

2 Replies
Gysbert_Wassenaar

How can the new and update records be distinguished from old records? Does your data include a modification date?


talk is cheap, supply exceeds demand
buzzy996
Master II
Master II

u can try some thing like this,

tab1:

ur old data

tab2:

ur new data

tab3:

by using not exists condition u can compare and load ur old and new data but new data will be generate a flag='1'

and in ur chart expression: use this flag as new record's & background of the object apply the color.