Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Calculation Time out Error in Chart

Hi,

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

how to eliminate that?

Any Suggestions?

5 Replies
shumailh
Contributor III

Calculation Time out Error in Chart

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

Not applicable

Calculation Time out Error in Chart

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

Calculation Time out Error in Chart

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

Shumail

Not applicable

Calculation Time out Error in Chart

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?





MVP
MVP

Calculation Time out Error in Chart

I think what you need is something like this:

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

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser