Discussion Board for collaboration on QlikView Scripting.
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
Go to Solution.
You could also exclude the filter rows from the data load using a NOT EXISTS:
A AS ExcludeValue
FROM (ooxml, embedded labels, table is B);
FROM (ooxml, embedded labels, table is A)
WHERE NOT EXISTS (ExcludeValue,A);
DROP FIELD ExcludeValue;
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.
LOAD * Inline [
NoConcatenate LOAD Distinct A Resident Data;
Outer Join (Temp) LOAD A as B Resident Data;
NoConcatenate LOAD A,B Resident Temp Where A <> B;
DROP Table Temp;
You may explore the feasibility of using Actions for "OnSelect" field A.
thank you very much