topic Eliminate rows from a table in QlikView

Eliminate rows from a table

Mon, 29 Jun 2015 13:08:16 GMT

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.

Re: Eliminate rows from a table

sunny_talwar — Mon, 29 Jun 2015 13:18:37 GMT

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

Re: Eliminate rows from a table

avinashelite — Mon, 29 Jun 2015 13:20:00 GMT

please find the attachment for the solution

Re: Eliminate rows from a table

Mon, 29 Jun 2015 13:27:01 GMT

Thanks....that worked first time

Re: Eliminate rows from a table

sunny_talwar — Mon, 29 Jun 2015 13:29:46 GMT

Hi Andrew -

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

Best,

Sunny

Re: Eliminate rows from a table

Anonymous — Mon, 29 Jun 2015 14:00:25 GMT

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