Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could also exclude the filter rows from the data load using a NOT EXISTS:
Filter:
LOAD
A AS ExcludeValue
FROM
Data:
LOAD
A,
B
FROM
WHERE NOT EXISTS (ExcludeValue,A);
DROP FIELD ExcludeValue;
Jonathan
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.
You could also exclude the filter rows from the data load using a NOT EXISTS:
Filter:
LOAD
A AS ExcludeValue
FROM
Data:
LOAD
A,
B
FROM
WHERE NOT EXISTS (ExcludeValue,A);
DROP FIELD ExcludeValue;
Jonathan
hi
thank you very much
it works
gidon