Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am new to Qlik
I have one table Operations and it has 1 numeric field Saldo and 2 date fields DtPrej and DtPrejGer, I want to sum the total Saldo for each month but there are those two different date fields, soooo how can I do it?
Is the business content different for the fields?
e.g.
Orders:
load *inline [
Fact, InvoiceDate, OrderDate
]
You could load a date field calculated of both fields and use the new dimension:
load
fact,
InvoiceDate,
OrderDate,
if (InvoiceDate is not null, InvoiceDate, OrderDate) as TotalDate
resident orders;