Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Actual date
Scheduled date
Customerbaseline date
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.
This:
Add this to all your 5 expressions:
If(Len(Trim(actualdate)) > 0 and Len(Trim(completeddelinquent)) > 0 and Len(Trim(customerbaseline)) > 0, YourExpression)
HTH
Best,
Sunny
Hi
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
Best,
Sunny
Hi Andrew,
in your script, use if function in conditional field and valid the dates in where clause, like this:
Load
Field1,
Field2,
Field3,
If(
actualdate > customerbaseline
And
scheduleddate > customerbaseline,
scheduleddate) AS projectdelinquent
Where
(Not IsNull(actualdate) And Not IsNull(customerbaseline) And Not IsNull(scheduleddate) )