Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to using load script to filter Reporting_Code<10026 ?

Hi All

I have below code :-

LOAD @1:13,

     @14:46,

     @106:122,

     @123:n as Reporting_Code

FROM

(fix, codepage is 1252, no eof);

it will display Reporting_Code as below :-

10000

10011

10026

10030

My Question is what is the script i need to add , so that it will only keep those Reporting Code less then 10026 ? So that my QV Doc will only have 2 row of record.

Paul ( I am using my friend account as my account cannot log in )

2 Replies
Not applicable

Re: How to using load script to filter Reporting_Code<10026 ?

my QV Doc

jonas_rezende
Valued Contributor

Re: How to using load script to filter Reporting_Code<10026 ?

Hi, Eksa Susanto.

Utilize clause where like below.

LOAD @1:13,

     @14:46,

     @106:122,

     @123:n as Reporting_Code

FROM

(fix, codepage is 1252, no eof)

where

@123:n < 10026;


I hope this helps!

Community Browser