topic Re: MAPPING WITH FUNCTIONS in QlikView

MAPPING WITH FUNCTIONS

Wed, 30 Apr 2014 06:32:42 GMT

Hi can anyone pls suggest whether the below mentioned script is possible in qlikview also suggest me if there is any alternative for the same

MAP:

Mapping

LOAD PLANT,

MAX(Amount)

FROM

C:\Users\Admin\Desktop\Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

Thanking You

Vinayagam

Re: MAPPING WITH FUNCTIONS

Wed, 30 Apr 2014 06:40:47 GMT

Hi,

It is not possible without using group by function as under:

MAP:

Mapping

LOAD PLANT,

MAX(Amount) as Amount

FROM

C:\Users\Admin\Desktop\Book1.xlsx

(ooxml, embedded labels, table is Sheet1)

group by PLANT;

Re: MAPPING WITH FUNCTIONS

Colin-Albert — Wed, 30 Apr 2014 06:40:53 GMT

You need to add a group by clause.

MAP:

Mapping

LOAD PLANT,

MAX(Amount)

FROM

C:\Users\Admin\Desktop\Book1.xlsx

(ooxml, embedded labels, table is Sheet1)

Group by PLANT ;

Re: MAPPING WITH FUNCTIONS

SunilChauhan — Wed, 30 Apr 2014 06:41:07 GMT

its need group by Plan in from

i mean your

load

mapping

Load PLANT,

Max(Amount) as MaxAmount

from above path

group by PLANT;

hope this helps

Re: MAPPING WITH FUNCTIONS

Wed, 30 Apr 2014 07:02:12 GMT

Thanks Friends for the valuable response ... Thank You