Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Allocated memory exceed in chart

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

Tags (2)
13 Replies
amit_saini
Honored Contributor III

Re: Allocated memory exceed in chart

Can you please upload sample here.

Thanks,
AS

VishalWaghole
Valued Contributor II

Re: Allocated memory exceed in chart

Hi Inna,

I think you calculate dimension is not correct.

Please check your calculated dimension.

Hope this will work for you.

-- Regards,

Vishal Waghole

Not applicable

Re: Allocated memory exceed in chart

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
Honored Contributor III

Re: Allocated memory exceed in chart

Try with this:

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

Thanks,

AS

aveeeeeee7en
Valued Contributor III

Re: Allocated memory exceed in chart

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

Cyclic or Drill-Down Approach.

Regards

Aviral Nag

aveeeeeee7en
Valued Contributor III

Re: Allocated memory exceed in chart

Create Cyclic or Drill-Down Groups:

Cyclic or Drill-Down Groups111.png

Not applicable

Re: Allocated memory exceed in chart

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

Not applicable

Re: Allocated memory exceed in 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.

sasikanth
Valued Contributor III

Re: Allocated memory exceed in chart

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')