Calculation Time out Error in Chart

[#1]

Hi,

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

how to eliminate that?

Any Suggestions?

[shumailh]

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

[#3]

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]

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

Shumail

[#5]

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]

I think what you need is something like this:

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

Jonathan