Discussion Board for collaboration on QlikView Scripting.
I have 3 fields
At the moment I have the following expression that excludes all of the records where the currentdelinquent field is = null
If(not isnull([completeddelinquent]),actualdate )
This works but it also returns records where actual date is = to blank and I also want to exclude these records.
I think I need to use set analysis combined with the formula above but can't get it to work
try e() you may get t
or try this
only( If(not isnull([completeddelinquent]),actualdate ) )
Thanks but that didn't work it left the blanks for actualdate and bought in the null fields for currendelinquent that I was excluding
Try like this
If(Len(Trim(Currentdelinquent)) = 0, 1, 0) AS IsNull
Now in front end you can use
OR you can try this without any changes in script
If(not Len(Trim(([completeddelinquent])) = 0,actualdate )
If(Len(Trim(([completeddelinquent])) > 0,actualdate )
This didn't work, it still bought in where the actual date is blank
Are you checking Blank for Actual date? Then use this
If(Len(Trim(([actualdate ])) > 0,actualdate )
If(Len(Trim(([actualdate ])) > 0, DimensionName)
Perhaps are You loading data from MySql ?