8 Replies Latest reply: Dec 17, 2017 11:15 PM by Dhana vindhan RSS

    Allocated Memory Issue

    Dhana vindhan

      Hi,

      I am facing this issue "Allocated Memory Exceeded" when I try to open one of the Pivot table in Qlikview sheet. I tried my level best to sort this issue but I couldn't. If any one know better solution to resolve this please enlighten me to sort this out. Below I am posted the expressions used on the table.

       

      Expression :

       

      1. =sum(Marketing.TEU)

      2. =if(vEquipType2='Dry20',  sum(if([Marketing.Equip Type]='FT20' or [Marketing.Equip Type]='OT20',[Marketing.TotFrgRev],0))/sum(if([Marketing.Equip Type]='FT20'

      or [Marketing.Equip Type]='OT20',[Marketing.RevTEU],0)),

      if(vEquipType2='Dry40',  sum(if([Marketing.Equip Type]='FT40' or [Marketing.Equip Type]='OT40'

      or [Marketing.Equip Type]='FR40' or [Marketing.Equip Type]='HC40',[Marketing.TotFrgRev],0))/sum(if([Marketing.Equip Type]='FT40'

      or [Marketing.Equip Type]='OT40' or [Marketing.Equip Type]='FR40' or [Marketing.Equip Type]='HC40',[Marketing.RevTEU],0)),

      if(vEquipType2='REEFER', sum(if([Marketing.Equip Type]='RF40',[Marketing.TotFrgRev],0))/sum(if([Marketing.Equip Type]='RF40',[

      Marketing.RevTEU],0)),sum([Marketing.TotFrgRev])/sum([Marketing.RevTEU]))))

       

      3. =if(vEquipType2='Dry20', 

      sum(if([Marketing.Equip Type]='FT20'

      or [Marketing.Equip Type]='OT20',OFR,0))/sum(if([Marketing.Equip Type]='FT20'

      or [Marketing.Equip Type]='OT20',[Marketing.RevTEU],0)) ,

       

      if(vEquipType2='Dry40',  sum(if([Marketing.Equip Type]='FT40'

          or [Marketing.Equip Type]='OT40'

          or [Marketing.Equip Type]='FR40'

          or [Marketing.Equip Type]='HC40',OFR,0))/sum(if([Marketing.Equip Type]='FT40'

          or [Marketing.Equip Type]='OT40'

          or [Marketing.Equip Type]='FR40'

          or [Marketing.Equip Type]='HC40',[Marketing.RevTEU],0)),

       

      if(vEquipType2='REEFER',

          sum(if([Marketing.Equip Type]='RF40',OFR,0))/sum(if([Marketing.Equip Type]='RF40',

          [Marketing.RevTEU],0)),sum(OFR)/sum([Marketing.RevTEU]))))