topic Re: filter data in QlikView

filter data

gidon500 — Sun, 04 Aug 2013 19:33:27 GMT

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

Re: filter data

nagaiank — Sun, 04 Aug 2013 20:44:48 GMT

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.

Re: filter data

Anonymous — Mon, 05 Aug 2013 07:29:57 GMT

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

FROM (ooxml, embedded labels, table is A)

WHERE NOT EXISTS (ExcludeValue,A);

DROP FIELD ExcludeValue;

Jonathan

Re: filter data

gidon500 — Mon, 05 Aug 2013 16:35:16 GMT

thank you very much

it works

gidon