Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Including Null Values

I have the following data set:

U-Date            Amount

7/8/2013         2280.00

-                      2227.50

10/24/2013     2475.00

-                      2475.00

6/24/2008        2475.00

I want to sum the amounts of U-Date greater than 7/1/2013 and include the - values.  I have tried different formulas and it is not working.  Any suggestions?

David

2 Replies
mov
Esteemed Contributor III

Re: Including Null Values

If it is in a text box, it could be:

sum(if("U-Date"> date('7/1/2013') OR len(trim("U-Date"))=0, Amount))

MVP
MVP

Re: Including Null Values

or perhaps

=sum(if ( alt([U-Date],'12/31/2099') > date('7/1/2013'), Amount))

Community Browser