load values by a criteria

[#1]

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);

[sunny_talwar · Accepted solution]

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');

[awhitfield]

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

[#4]

Thank you, It works perfectly.

[sunny_talwar]

Awesome! I am glad it worked.

Best,

Sunny

[vvvvvvizard]

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

[Anonymous]

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