topic Re: How to skip to next record in QlikView

How to skip to next record

Anonymous — Mon, 10 Apr 2017 14:11:23 GMT

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 ?

Re: How to skip to next record

sunny_talwar — Mon, 10 Apr 2017 14:12:35 GMT

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?

Re: How to skip to next record

Anonymous — Mon, 10 Apr 2017 14:13:42 GMT

LOAD

...

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

LOAD

...

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

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

Re: How to skip to next record

Anonymous — Mon, 10 Apr 2017 15:13:13 GMT

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

]

Re: How to skip to next record

Anil_Babu_Samineni — Mon, 10 Apr 2017 15:17:15 GMT

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,

];

Re: How to skip to next record

Anonymous — Mon, 10 Apr 2017 15:18:53 GMT

noconcatenate

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