topic move expression into the script in QlikView

move expression into the script

Wed, 17 Jul 2013 08:02:49 GMT

Hi i have a rather complex expression i wish to move into my script.

i have attached the qvw to this message.

the expression i am looking to move is the following

sum({<Bol_ID-={'003'}>} aggr(distinct max({<Bol_ID-={'003'}>} Lagersaldo) *(max({<Bol_ID-={'003'}>} [Vägt Inpris])) ,ArtNr));

your help is greatly appreciated;

bradley,

Thu, 18 Jul 2013 16:16:30 GMT

Try using another table for the calculation in the script, like this one

MyTable:

LOAD Distinct

Artikelkat,

Max(Lagersaldo) * Max([Vägt Inpris]) AS Expr

Resident Article

Where Bol_ID <> '003'

Group By Artikelkat;

Maybe you are looking for Max(Lagersaldo * [Vägt Inpris]), but I am not sure.