Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
gidon500
Contributor II

filter data

Hello

i have a list a data in the enclosed excel file

data is located in sheet A

filter is located in sheet B

the output needed is as written in sheet C ( filted the lines vakue in sheet B )

how do i make it in qlikview commands

thanks

gidon

Tags (1)
1 Solution

Accepted Solutions
jonbrough
Valued Contributor

Re: filter data

You could also exclude the filter rows from the data load using a NOT EXISTS:

Filter:

LOAD

          A AS ExcludeValue

FROM (ooxml, embedded labels, table is B);

Data:

LOAD

          A,

          B

FROM (ooxml, embedded labels, table is A)

WHERE NOT EXISTS (ExcludeValue,A);

DROP FIELD ExcludeValue;

Jonathan

3 Replies
nagaiank
Valued Contributor III

Re: filter data

One method is the use of "as of" table approach. You may use the following script to build "as of" table. Define a Listbox for field B, and a Table Box for fields A and Val.

Data:

LOAD * Inline [

A, Val

1,10

2,20

3,30

4,40

];

Temp:

NoConcatenate LOAD Distinct A Resident Data;

Outer Join (Temp) LOAD A as B Resident Data;

AsOfTable:

NoConcatenate LOAD A,B Resident Temp Where A <> B;

DROP Table Temp;

You may explore the feasibility of using Actions for "OnSelect" field A.

jonbrough
Valued Contributor

Re: filter data

You could also exclude the filter rows from the data load using a NOT EXISTS:

Filter:

LOAD

          A AS ExcludeValue

FROM (ooxml, embedded labels, table is B);

Data:

LOAD

          A,

          B

FROM (ooxml, embedded labels, table is A)

WHERE NOT EXISTS (ExcludeValue,A);

DROP FIELD ExcludeValue;

Jonathan

gidon500
Contributor II

Re: filter data

hi

thank you very much

it works

gidon

Community Browser