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
I think you calculate dimension is not correct.
Please check your calculated dimension.
Hope this will work for you.
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, 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.
create some thing like below
create a inline table
Load * Inline [
then use the below expression as your values