topic IF formulas for date fields in QlikView

IF formulas for date fields

Mon, 07 Jan 2013 15:07:37 GMT

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]))

Re: IF formulas for date fields

nagaiank — Mon, 07 Jan 2013 15:14:06 GMT

Try

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

Re: IF formulas for date fields

Mon, 07 Jan 2013 15:20:01 GMT

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.