2 Replies Latest reply: May 22, 2013 9:53 AM by Bradley Coyne RSS

    Calcluation ontop of expression

    Bradley Coyne

      Hi.

       

      i have the following issue;

       

      i have three companies 000,001,003.

       

      i run a expression to bring forth a value; I purposely ignore 003 as i want it to be 0 (it carrys into qlikview a strange value that needs to be surpressed.

       

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

       

      everything works fine until i wish to select all three companies to do a consolidation. when i do this i get '0'.

       

      is there any way i can adjust the code above in the front-end to sum up 000 and 001 and ignore 003 when selecting all 3 companies?

       

      Best,

      Bradley