topic Re: load expression in QlikView

load expression

jtrillori — Mon, 18 Mar 2013 08:38:31 GMT

Mornig

I have a trouble withe a load script, maybe you can help me.

i have a invoice table, each invoice has a multiple departments and i want identify the department with the higher particaption on the invoice

the result must be.

INVOICE1 = DEPARTMENT2 (800+400)

INVOICE2= DEPARTMENT3 (800)

INVOICE3 = DEPARTMENT1 (400)

INVOICE4 = DEPARTMENT3 (500)

Can you help me??

thanks and regards

jagan — Mon, 18 Mar 2013 08:52:18 GMT

Hi,

Please find attached file for solution.

Regards,

jagan.

Mon, 18 Mar 2013 09:47:31 GMT

try this

LOAD INVOICE,

DEPARTMENT,

VALUE

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD INVOICE,

MAX(MAXVALUE) AS MAX,

FirstSortedValue(DEPARTMENT,-MAXVALUE) as DEPARTMENT1

Group by INVOICE;

T2:

LOAD INVOICE,

DEPARTMENT ,

SUM(VALUE) AS MAXVALUE

Resident T

Group BY DEPARTMENT ,INVOICE;

DROP Table T;

then output like this

jtrillori — Wed, 20 Mar 2013 17:49:13 GMT

working nice with the two options.

thanks