Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Eliminate rows from a table

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.

5 Replies
sunny_talwar

This:

Capture.PNG

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

avinashelite

Hi

please find the attachment for the solution

Not applicable
Author

Thanks....that worked first time

sunny_talwar

Hi Andrew -

If you got your answer, I would recommend closing the thread by marking the correct answer

Best,

Sunny

Anonymous
Not applicable
Author

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) )