topic How to add another filter for limit loadf in QlikView

How to add another filter for limit loadf

paulyeo11 — Mon, 07 Sep 2015 05:58:37 GMT

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

Re: How to add another filter for limit loadf

Mon, 07 Sep 2015 06:02:17 GMT

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

Re: How to add another filter for limit loadf

Mon, 07 Sep 2015 06:03:59 GMT

can u attach qvw?

Re: How to add another filter for limit loadf

Mon, 07 Sep 2015 06:13:57 GMT

Hi,

can you attach your application.

Re: How to add another filter for limit loadf

sasiparupudi1 — Mon, 07 Sep 2015 08:02:35 GMT

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

Re: How to add another filter for limit loadf

Anonymous — Mon, 07 Sep 2015 08:23:36 GMT

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

Re: How to add another filter for limit loadf

paulyeo11 — Mon, 07 Sep 2015 08:30:02 GMT

Hi sir

I got error msg

Re: How to add another filter for limit loadf

Anonymous — Mon, 07 Sep 2015 08:33:40 GMT

remove noconcatenate

Re: How to add another filter for limit loadf

paulyeo11 — Mon, 07 Sep 2015 09:00:32 GMT

Hi Sir

Thank you very much.

Paul

Re: How to add another filter for limit loadf

paulyeo11 — Sun, 13 Sep 2015 12:43:29 GMT

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

Re: How to add another filter for limit loadf

Anonymous — Sun, 13 Sep 2015 14:16:46 GMT

Hi Paul,

Its just matter of learning from forum about basics and practice.

please go thru below links and get acquainted with basics of data modelling.

Posts by Henric

Get started with developing qlik datamodels

Advanced topics for creating a qlik datamodel

Re: How to add another filter for limit loadf

paulyeo11 — Sun, 13 Sep 2015 14:25:12 GMT

Hi Sir

Thank you for feed me so many interesting link By the way HIC is one my most respected person in design blog.

Paul

Sent from my iPhone