Discussion Board for collaboration on QlikView Scripting.
Cananyone help me. I've attached my qvw script
I'm having problems elminating records from the view called Completed MIlestones Delinquent. I've tried several options but can't seem to get it do to what I need
I have 3 fields
And I only want to show the records where all three fields are populated, if they are blank or null I want to exclude them.
The scheduled date field is from a calculated field in the script called completeddelinquent.
Add this to all your 5 expressions:
If(Len(Trim(actualdate)) > 0 and Len(Trim(completeddelinquent)) > 0 and Len(Trim(customerbaseline)) > 0, YourExpression)
please find the attachment for the solution
Thanks....that worked first time
Hi Andrew -
If you got your answer, I would recommend closing the thread by marking the correct answer
in your script, use if function in conditional field and valid the dates in where clause, like this:
actualdate > customerbaseline
scheduleddate > customerbaseline,
scheduleddate) AS projectdelinquent
(Not IsNull(actualdate) And Not IsNull(customerbaseline) And Not IsNull(scheduleddate) )