12 Replies Latest reply: Mar 31, 2016 1:00 AM by PAUL YEO RSS

    when my chart compute sales contribution for all company i get out of memory error

    PAUL YEO

      Hi All

       

       

      I have below expression working fine for last 5 yr :-

      sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}

      $(ColumnDim51)/$(Columndim89))

      /

      sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}

      TOTAL <$(ColumnDim_p)

      > $(ColumnDim51)/$(Columndim89))

       

       

      My only issue is it take very long time to plot the chart.  May i know it there any way to speed up in plot the chart ?

       

       

      Now i create a small data file , it will not cause out of memory error. so that you know what i mean.

       

       

      Edit :- This issue getting worst is if i need to analyse all company sales contribution by dimension. ( ?in the past i only analyse one company at a time , no issue , i can wait, but if analyse all company i get out of memory issue )

       

      Enclosed my QV sample in my next posting.

       

      Paul