Allocated memory exceed in chart

[#1]

Hi everyone!

I am begginer in QV and have some, maybe, simple question. I tryed to build chart with calculate dimention (change the x-axis depending on selection in list box - Date, Week, Month and Year), but when I put expression like sum(Payments) i get "Allocated memory exceed" (when I put sum(1) it works well).

Could you suggest me something to avoid it?

thanks in advance

[amit_saini]

Can you please upload sample here.

Thanks,
AS

[VishalWaghole]

Hi Inna,

I think you calculate dimension is not correct.

Please check your calculated dimension.

Hope this will work for you.

-- Regards,

Vishal Waghole

[#4]

I can't upload a sample, because have not access to Internet from working server with QV.

I used two variables for calculate dimension:

1. Period_chart2=if( GetFieldSelections(Period)='Date',1, if(GetFieldSelections(Period)='Week',2,if(GetFieldSelections(Period)='Month',3,4)))  // the number of selection

2.Period_chart=pick($(Period_chart2), [Date], [Year_Week] ,[Year_Month], [Year]) //select dimension according to number

and in calculate dimension I write =$(Period_chart)

Thanks

[amit_saini]

Try with this:

2.Period_chart=pick($(Period_chart2), Date, Year_Week,Year_Month, Year)

Thanks,

AS

[aveeeeeee7en]

Instead of doing all such Calculation using Variables and Calculated Dimension you can use:

Cyclic or Drill-Down Approach.

Regards

Aviral Nag

[aveeeeeee7en]

Create Cyclic or Drill-Down Groups:

[#8]

Isn't work (message "Allocated..." remain). But for chart expression like =sum(1) it works perfectly. maybe, thare are problems with row data(

[#9]

Thanks, but I have different variables for different dimensions (For Date is one variable, for Week another) - that's why I did not use it. And there are plenty of charts on worksheet. It Would be much easier to have a selection table.

[sasikanth]

hi

create some thing like below

create a inline table

Load * Inline [

KPI

1

2

3

4

5

];

then use the below expression as your values

PICK(Match(KPI, 1,2,3,4),'Date','Week','Month','year')