Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

if Statement Expression

hi having trouble with the following logic.

My first expression works great however i would like to add the following logic to the statement.

I have a field for company code and depending on the company code i would like the expression to work,

so for example

if(Bol_ID = '000' or Bol_ID = '001' then do the following (code below)  else show 0.

sum(

Aggr(

DISTINCT

Max(Artikel.Lagersaldo) * Max([Artikel.Vägt inpris])

,

Artikel.ArtikelNr

)

)

Help is much appreciated.

best,

Brad

1 Solution

Accepted Solutions
Not applicable

Re: if Statement Expression

This may work:

sum(if(Bol_ID = '000' or Bol_ID = '001', Aggr(DISTINCT Max(Artikel.Lagersaldo) * Max([Artikel.Vägt inpris]),Artikel.ArtikelNr )))

Hope that helps.

Matt

1 Reply
Not applicable

Re: if Statement Expression

This may work:

sum(if(Bol_ID = '000' or Bol_ID = '001', Aggr(DISTINCT Max(Artikel.Lagersaldo) * Max([Artikel.Vägt inpris]),Artikel.ArtikelNr )))

Hope that helps.

Matt

Community Browser