Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
43918084
Creator II
Creator II

Define New , Exist, mature between Trades in 2 tables

I have 2 tables , Current and Last year.  I want to add one more field "status" to define

New  = if Trade ID exists only in [Current] table

Exist = if Trade ID exists in both tables

Matured = If Trade ID exists in [Last Year] table and Matdate > Report date

I only know how to create in Excel formula but do not know how to create in Qlik sense. 

Would like to seek expertise on it.

 

Current    
Report dateTradeIDMatDateTradeDateNotional
20200131new1202012302018103050
20200131new220201230201810302
20200131ex12020123020181030100
20200131ex12020123020181030100
     
     
     
last year    
Report dateTradeIDMatDateTradeDateNotional
20191231ex12020123020181030100
20191231ex12020123020181030100
20191231mat1202012302018103010
20191231Term120201230201810301
Labels (2)
0 Replies