Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to add another filter for limit loadf

Hi All

I have below script , which can filter BRAND_SUB=HAKKO from sales Table :-

NewFilteredTable:

NOCONCATENATE

LOAD *

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.

Paul

1 Solution

Accepted Solutions
Anonymous
Not applicable

remove noconcatenate

View solution in original post

11 Replies
Not applicable

while loading the 2 table u have to apply where clause; other than that i dont think some possibility exists.

Not applicable

can u attach qvw?

Not applicable

Hi,

can you attach your application.

sasiparupudi1
Master III
Master III

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

hth

Sasi

Anonymous
Not applicable

hi paul,

try below code if key fields are matching:

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT ARSummary WHERE TERMS='30 DAY';

DROP TABLES ARSummary;

join(NewFilteredTable)

NOCONCATENATE

LOAD *

RESIDENT Q_DOD_2015 WHERE GROUP='BP';

DROP TABLES Q_DOD_2015;

Final:

NOCONCATENATE

LOAD *

RESIDENT NewFilteredTable

WHERE TERMS='30 DAY' and GROUP='BP';

DROP TABLES NewFilteredTable;


Regards

Neetha

paulyeo11
Master
Master
Author

Hi sir

I got error msg

error filter twice.png

Anonymous
Not applicable

remove noconcatenate

paulyeo11
Master
Master
Author

Hi Sir

Thank you very much.

Paul

paulyeo11
Master
Master
Author

Hi Neetha

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 ?

Paul