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: 
BTIZAG_OA
Creator
Creator

How to find if value exist before in date column

Hello all,

i need help with this kind of expression.

I have table like this,

key,name,vendor,host,date, ... columns (key is created with name&'|'&vendor&'|'&host)

i have to show new records on table, but not if name is avaible in older date.

in order this i check max(date) and max(date,2)  and flag records on key field if its current on maxdate and not current on maxdate2.

 

now on the table object i need to show new records. But i cant make it, not show if NAME vlaue exists on older date. qlik not let me use exist() func. on table object.

 

i tried this expression =If (flag=1 and aggr(Count({1}date),name) =1,name,null()) to get it but it miss some data like this example.

if same name on the same maxdate(same name value can be on different host) makes it date count more than 1 and miss this row on the table. How can i achieve to show new records on table object while, exclude if name value exits on older date? 😞

2 Replies
Kushal_Chawda

@BTIZAG_OA  not sure I am following that. Please share sample data with expected output

BTIZAG_OA
Creator
Creator
Author