Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: Eliminate rows from a table

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

Re: Eliminate rows from a table

Hi

please find the attachment for the solution

Not applicable

Re: Eliminate rows from a table

Thanks....that worked first time

Re: Eliminate rows from a table

Hi Andrew -

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

Best,

Sunny

evandro_segura
New Contributor III

Re: Eliminate rows from a table

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


Community Browser