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

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

paulyeo11 — Tue, 29 Mar 2016 23:58:13 GMT

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

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

paulyeo11 — Tue, 29 Mar 2016 23:59:04 GMT

My Qv sample

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

settu_periasamy — Wed, 30 Mar 2016 03:44:55 GMT

Hi Paul,

Check the Attachment.

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

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

paulyeo11 — Wed, 30 Mar 2016 04:23:15 GMT

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

settu_periasamy — Wed, 30 Mar 2016 04:24:57 GMT

You are Welcome 🙂

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

paulyeo11 — Wed, 30 Mar 2016 04:28:00 GMT

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

settu_periasamy — Wed, 30 Mar 2016 04:39:50 GMT

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.

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

paulyeo11 — Thu, 31 Mar 2016 00:37:57 GMT

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.

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

paulyeo11 — Thu, 31 Mar 2016 00:41:35 GMT

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

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

Gabriel — Thu, 31 Mar 2016 01:02:46 GMT

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.

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

paulyeo11 — Thu, 31 Mar 2016 01:48:56 GMT

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

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

settu_periasamy — Thu, 31 Mar 2016 04:33:04 GMT

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.

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

paulyeo11 — Thu, 31 Mar 2016 05:00:19 GMT

Hi Settu

Thank you very much.

Paul