Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
luizasch
Contributor
Contributor

Sum two measures with different dimension fields

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?

1 Reply
johannesholzer
Contributor III
Contributor III

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;