How to skip to next record

[Anonymous]

Hi I want to know how to tell qlikview to skip to the next record if for instance a value is blank.

So I want to say for instance

If len(SALES_PERSON)<1  /// SALES_PERSON FIELD IS BLANK

   then skip to next record    ////MOVE ONTO NEXT RECORD

Is this possible ?

[sunny_talwar]

Where are you doing this? In the script? Would you be able to share few rows of data and the output you are hoping to see?

[Anonymous]

LOAD

...

where previous(len(SALES_PERSON)>=1);

or

LOAD

...

where not previous(len(SALES_PERSON)<1);

It depends how you like to deal with null() and the first row.

[Anonymous]

Hi Sunny

Ignoring the field names I put in my original post, to make it simpler if I have a field ie SALES_TARGET_MET which is a mandatory field and allows either YES / NO. All I want to do is filter out any of the unanswered ones

So  I currently have :

[

LINE_ID, SALESPERSON, SALES_TARGET_MET

1, BOB, Y

2, RAY,

3, SMITH,N

4, ALLEN, N

5, TOBY,

]

I want to filter out the unanswered questions and return the following

[

LINE_ID, SALESPERSON, SALES_TARGET_MET

1, BOB, Y

3, SMITH,N

4, ALLEN, N

]

[Anil_Babu_Samineni]

I used this. I am sorry if i misunderstand the expected result

LOAD * Where Len(SALES_TARGET_MET)>0;

LOAD * Inline

[

LINE_ID, SALESPERSON, SALES_TARGET_MET

1, BOB, Y

2, RAY,

3, SMITH,N

4, ALLEN, N

5, TOBY,

];

[Anonymous]

noconcatenate

LOAD * resident YOURTABLE where len(trim(SALESPERSON, SALES_TARGET_MET))<>0;