Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Valued Contributor II

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
neetha_p
Honored Contributor

Re: How to add another filter for limit loadf

remove noconcatenate

11 Replies
Not applicable

Re: How to add another filter for limit loadf

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

Not applicable

Re: How to add another filter for limit loadf

can u attach qvw?

Not applicable

Re: How to add another filter for limit loadf

Hi,

can you attach your application.

sasiparupudi1
Honored Contributor III

Re: How to add another filter for limit loadf

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

neetha_p
Honored Contributor

Re: How to add another filter for limit loadf

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
Valued Contributor II

Re: How to add another filter for limit loadf

Hi sir

I got error msg

error filter twice.png

neetha_p
Honored Contributor

Re: How to add another filter for limit loadf

remove noconcatenate

paulyeo11
Valued Contributor II

Re: How to add another filter for limit loadf

Hi Sir

Thank you very much.

Paul

paulyeo11
Valued Contributor II

Re: How to add another filter for limit loadf

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