Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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

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

1 Solution

Accepted Solutions

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

Hi Paul,

Check the Attachment.

I just removed the Dimension Limit and applied the Rank function in the
Expression..

12 Replies
paulyeo11
Valued Contributor II

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

My Qv sample

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

Hi Paul,

Check the Attachment.

I just removed the Dimension Limit and applied the Rank function in the
Expression..

paulyeo11
Valued Contributor II

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

Hi Settu

wow , thank you so much for your help , and it work supper fast now.

Paul

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

You are Welcome :-)

paulyeo11
Valued Contributor II

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

Hi Settu

why you just add a Rank , it create so much impact to the speed ? can you share ?

Paul

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

The Alternate of Dimension Limit is Rank function. Just i tried it.

And, i saw that you are using aggregated calculated dimension.

I read that, this will also create the bad performance.

paulyeo11
Valued Contributor II

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

what is the different ?

Hi All

The chart 3 still very slow if i do the following step :-

step 1 :- Duplicate chart 2 and rename the chart to chart 3.

Step 2 :- I go chart 1 click on the expression ( and i select all the expression by control A and control C for copy).

Step 3 :- I go to chart 3 , i open the existing expression and paste on it.

The chart 3 become very fast if i do the following step :-

step 1 :- Duplicate chart 2 and rename the chart to chart 3.

Step 2 :- I go chart 1 copy the expression ( By right click mouse copy the whole expression ).

Step 3 :- I go to chart 3 , delete the existing expression. and paste the new expression in.

paulyeo11
Valued Contributor II

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

Hi settu

I just post my QV sample file to you again , because i am not sure where you change beside you change the expression.

As you notice from my post 1 min ago , if i copy the expression whole , my chart will become very fast. if i only copy the expression only , the chart still very slow.

Can you tell me why ?

Paul

Gabriel
Valued Contributor II

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

Hi,

Your calculations seems to be expensive on UI. I will suggest using Calendar Flags in your calculations. There are several calendar on community which will help simplify your expression. 

Community Browser