Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

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.