topic Syntax Set analysis - calculation in QlikView

Syntax Set analysis - calculation

Fri, 07 Jun 2013 07:06:16 GMT

I have an expression (see below)

sum({<Bol_ID-={'003'}>} aggr(distinct max({<Bol_ID-={'003'}>} Artikel.Lagersaldo) *

(max({<Bol_ID-={'003'}>} [Artikel.Vägt inpris] )) ,Artikel.ArtikelNr))

Ontop of this expression i would like to * by a currency see below

BAS_CROSS_inv_FSG_KURS

sum({<Bol_ID-={'003'}>} aggr(distinct max({<Bol_ID-={'003'}>} Artikel.Lagersaldo) *

(max({<Bol_ID-={'003'}>} [Artikel.Vägt inpris] )) ,Artikel.ArtikelNr)) * BAS_CROSS_inv_FSG_KURS;

However this calculation is not working;

Help is greatly appreciated.

Best

Brad

Re: Syntax Set analysis - calculation

Fri, 07 Jun 2013 07:30:35 GMT

Sorry bracoy to interrupt,

but Mohit do u have any help notes or sticky notes for improving skills on SET Analysis, m very poor in tht,

if i get confused in it i prefer using if else then,

Please share if u hav any

Re: Syntax Set analysis - calculation

Fri, 07 Jun 2013 07:32:36 GMT

Hi.

unfortunately the calculation at the bottom returns a 0 result;

any ideas?

Best,

Brad

Re: Syntax Set analysis - calculation

Fri, 07 Jun 2013 07:52:50 GMT

Actually what i was thinking we could do is isolate this in the expression, however my syntax is wrong could you point me in the right direction, thanks for your help so far;

= [Artikel.Vägt inpris] * BAS_CROSS_inv_FSG_KURS

sum({<Bol_ID-={'003'}>} * BAS_CROSS_inv_FSG_KURS={'**'},aggr(distinct max({<Bol_ID-={'003'}>} Artikel.Lagersaldo) *(max({<Bol_ID-={'003'}>} [Artikel.Vägt inpris] * BAS_CROSS_inv_FSG_KURS)) ,Artikel.ArtikelNr))

Best,

Bradley