Discussion Board for collaboration related to Creating Analytics for QlikView.
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(DISTINCTMax(Artikel.Lagersaldo) * Max([Artikel.Vägt inpris]),Artikel.ArtikelNr ))
Help is much appreciated.
Go to Solution.
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.