topic Re: load values by a criteria in QlikView

load values by a criteria

Fri, 08 May 2015 14:20:37 GMT

Hi,

I'm new on using QlikView, please can you help me with some suggestions...I want to load sales values only for CUST_NAME - ABCD and YYYYY.

Thank you

Sales:
CUST_ID	Sales
111	100
222	200
333	300
333	500
Customer:
CUST_ID	CUST_NAME
111	MMMM
222	YYYYY
333	ABCD

LOAD CUST_ID,
Sales
FROM
...\Sales.xlsx
(ooxml, embedded labels, table is Sheet1);

LOAD CUST_ID,
CUST_NAME
FROM
.....Customer.xlsx
(ooxml, embedded labels, table is Sheet1);

Re: load values by a criteria

sunny_talwar — Fri, 08 May 2015 15:34:15 GMT

You can do something like this:

Table1:

LOAD CUST_ID,

Sales

FROM Sales.xlsx

(ooxml, embedded labels, table is Sheet1);

Table2:

Right Keep (Table1)

LOAD CUST_ID,

CUST_NAME

FROM Customer.xlsx

(ooxml, embedded labels, table is Sheet1)

Where Match(CUST_NAME, 'YYYYY', 'ABCD');

Re: load values by a criteria

awhitfield — Fri, 08 May 2015 15:58:12 GMT

HI Agata,

you can try this out

LOAD CUST_ID,
CUST_NAME
FROM

(ooxml, embedded labels, table is Sheet2)
WHERE(CUST_NAME = 'YYYYY' OR CUST_NAME = 'ABCD');

regards

Andy

Re: load values by a criteria

Fri, 08 May 2015 17:49:00 GMT

Thank you, It works perfectly.

Re: load values by a criteria

sunny_talwar — Fri, 08 May 2015 17:50:24 GMT

Awesome! I am glad it worked.

Best,

Sunny

Re: load values by a criteria

vvvvvvizard — Fri, 08 May 2015 19:32:05 GMT

WHERE(Upper(CUST_NAME) = 'YYYYY' OR Upper(CUST_NAME) = 'ABCD');

Re: load values by a criteria

Anonymous — Fri, 08 May 2015 20:01:19 GMT

Now it's a good time to mark Sunny's response as "Correct"