filter data

[gidon500]

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

[nagaiank]

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.

[Anonymous · Accepted solution]

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]

hi

thank you very much

it works

gidon