Discussion Board for collaboration on QlikView Scripting.
I have below script , which can filter BRAND_SUB=HAKKO from sales Table :-
RESIDENT sales WHERE BRAND_SUB='HAKKO';
DROP TABLES sales;
In my QVW file i have 2 table , which is ARSummary Table , and i also want to filter another field , SEGMENT=Other.
Hope some one can advise me how to modify the above , so that it can filter more then 1 table.
Solved! Go to Solution.
you can join the two tables and then you can filter on the fields from the two tables.
It would be nice if you can post a sample application or post your script with the details of your field that you want to filter
try below code if key fields are matching:
RESIDENT ARSummary WHERE TERMS='30 DAY';
DROP TABLES ARSummary;
RESIDENT Q_DOD_2015 WHERE GROUP='BP';
DROP TABLES Q_DOD_2015;
WHERE TERMS='30 DAY' and GROUP='BP';
DROP TABLES NewFilteredTable;
When you give the the script , you did not get my raw data to test your script right ? May i know how to train yourself to be able to do this ?