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 date | TradeID | MatDate | TradeDate | Notional |
20200131 | new1 | 20201230 | 20181030 | 50 |
20200131 | new2 | 20201230 | 20181030 | 2 |
20200131 | ex1 | 20201230 | 20181030 | 100 |
20200131 | ex1 | 20201230 | 20181030 | 100 |
| | | | |
| | | | |
| | | | |
last year | | | | |
Report date | TradeID | MatDate | TradeDate | Notional |
20191231 | ex1 | 20201230 | 20181030 | 100 |
20191231 | ex1 | 20201230 | 20181030 | 100 |
20191231 | mat1 | 20201230 | 20181030 | 10 |
20191231 | Term1 | 20201230 | 20181030 | 1 |