Discussion Board for collaboration on QlikView Scripting.
I have the following data set:
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?
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))
=sum(if ( alt([U-Date],'12/31/2099') > date('7/1/2013'), Amount))