Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Valued Contributor III

Re: IF formulas for date fields

Try

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

Not applicable

Re: IF formulas for date fields

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.


Community Browser