topic Re: Sum two measures with different dimension fields in App Development

Sum two measures with different dimension fields

luizasch — Wed, 15 Jan 2020 14:24:57 GMT

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?

Re: Sum two measures with different dimension fields

johannesholzer — Wed, 15 Jan 2020 14:34:41 GMT

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;