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

[paulyeo11]

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

[paulyeo11]

I have already found the solution from Settu , now the chart is very fast , I just don't know where Settu change that make it fast .

Paul

Sent from my iPhone

[settu_periasamy]

Hi Paul,

The below steps i did:

1. Unchecked the Dimension Limit - Restrict Value. We can limit the value based on rank function.

  -> In the dimension limit, you set as First 16.  I used in the rank function which is <=15

2. Expression Tab : First 15  values based on Rank function.

3. Number Tab : Integer and show in Percent (%)

That's it..

Edit

You can remove the dimension limit, when we use rank function in expression.

In your app, When i select some diametric value, my system got hanged.

[paulyeo11]

Hi Settu

Thank you very much.

Paul