topic lookup function with example pls? in QlikView

lookup function with example pls?

Tue, 11 Feb 2014 12:33:33 GMT

lookup function with example pls? simple example to understand

thanks in advance

Re: lookup function with example pls?

luis_pimentel — Tue, 11 Feb 2014 12:39:03 GMT

Review the attached document. Its a good example about lookup function.

Regards,

Luis.

Re: lookup function with example pls?

Tue, 11 Feb 2014 12:39:29 GMT

Lookup function

Re: lookup function with example pls?

MK_QSL — Tue, 11 Feb 2014 13:20:56 GMT

Please check enclosed file...

Re: lookup function with example pls?

MK_QSL — Tue, 11 Feb 2014 13:24:36 GMT

One More... this will show you this year vs last year sale.

Re: lookup function with example pls?

Tue, 11 Feb 2014 13:44:10 GMT

i am using personal edition i can not open that file pls share some other file

Re: lookup function with example pls?

Tue, 11 Feb 2014 13:50:29 GMT

Hi Manoj,

PFA,

it helps alot i hope.

regards

MAhesh T

Re: lookup function with example pls?

MK_QSL — Tue, 11 Feb 2014 13:50:31 GMT

SaleLastYear:

Load * Inline

[

Customer_ID, Sales2012

A, 500

B, 600

C, 700

D, 400

E, 1000

F, 800

];

Sales:

Load *,

Lookup('Sales2012','Customer_ID', ID,'SaleLastYear') as LYSale

Inline

[

ID, Month2013, Sales

A, Jan, 100

B, Jan, 200

C, Jan, 300

D, Feb, 150

E, Mar, 200

F, Apr, 100

A, May, 140

D, May, 80

E, May, 100

F, Jun, 150

];

Now create a straight table with

ID as Dimension

and

SUM(Sales) as Expression 1 For Current Year

SUM(LYSale) as Expression 2 For Last Year...