topic Calculation Time out Error in Chart in QlikView

Calculation Time out Error in Chart

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I am getting Calculation Timed Out in my Chart in Accesspoint .

how to eliminate that?

Any Suggestions?

shumailh — Mon, 02 Aug 2010 07:08:36 GMT

Hi Blessy,

Can you post your expression script and a couple sample lines of data?

This may be because of heavy calculation, or your memory is full. In the initial days i was having similar sort of problem see the link http://community.qlik.com/forums/p/17478/68652.aspx#68652

Shumail

Mon, 02 Aug 2010 07:43:38 GMT

Expressions Used

1) sum(if(Time< $(TimeValue),PassedStatus))

2) ((sum(if(Time< $(TimeValue),PassedStatus,0)))/(sum(PassedStatus)))*100

Variable TimeValue can be 1 0r 2 0r anything based on my selection in slider.

Data Handled is like this

Tab1:

Load

ID,

if(Status=Pass,1,0) as PassedStatus

from ....

Tab2:

Load ID,

Time from ....where exists (ID) ;

shumailh — Mon, 02 Aug 2010 07:53:43 GMT

Try using set analysis instead of if condition. and read this discussion as well : http://community.qlik.com/forums/t/17188.aspx

Shumail

Mon, 02 Aug 2010 08:17:33 GMT

Hi,

Can you help out in Set Analysis syntax for

Actually

sum( {$<Time =$(TimeValue)})>} PassedStatus )

When i am using this I am getting sum of equal to that time .I want less than that time.wats the syntax for this less than that time?

jonathandienst — Mon, 02 Aug 2010 09:48:21 GMT

I think what you need is something like this:

sum( {$<Time={"<$(TimeValue)"})>} PassedStatus )

Jonathan