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

IF formulas for date fields

I want to write an expression for a chart that says if the bill date field is populated, sum the total request amount. I have most of it but I don't know what to put in place of 'Billed'. Any suggestions?

=sum(if([[Bill Date]]= 'Billed', [Total Request Amount]))

2 Replies
nagaiank
Specialist III
Specialist III

Try

=sum(if(Len(trim([Bill Date]))>0, [Total Request Amount]))

Not applicable
Author

Hmmm...I underestimated the complexity.

I want to show a few things:

Invoices with LOG

Sum (Total Request Amount) if LOG Received (checkbox) = Yes and Invoice Received (checkbox) = Yes and Bill Date (date) = Blank.

Missing a LOG

Sum (Total Request Amount) if LOG Received (checkbox) = No and Invoice Received (checkbox) = Yes and Bill Date (date) = Blank.

Missing an Invoice

Sum (Total Request Amount) if LOG Received (checkbox) = Yes and Invoice Received (checkbox) = No and Bill Date (date) = Blank.