Generic date with conditions

MagnusS — Thu, 24 Jan 2019 11:54:40 GMT

Hi,

I have a problem which I cant find a solution to which I hope you can help me with.

I have a financial qlikview report which has a datamodel with fact table on invoice level, each row shows several dates - invoicedate, paiddate, paymentbatch date. The facttable also has a flag showing invoicetype (Open, Paid).

Request is to create a new Report Date which should have conditions:

If InvoiceType = OP, then PaymentBatchDate <= ReportDate

If InvoiceType = PP, then InvoiceDate <= ReportDate and PaidDate >=ReportDate

I have created a DateLink table with the different date fields and connected it to a Master Calender, so I have a generic Date which we can call ReportDate. The problem I face is how I can apply the conditions to this Report Date? I tried with set analysis, but do not get it to work. I would prefer to create the conditions at script level so I can apply time relative measures on Report Date.

Any ideas?

topic Generic date with conditions in QlikView

Generic date with conditions