Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

after running the script the script is executed completed but my application is not responding

Hi

The script is not responding despite of complete execution and the application is hanging what may be the reason

24 Replies
tresesco
MVP
MVP

Could you post a screen shot of your issue?

Anonymous
Not applicable
Author

This application is not responding issue.png

jonathandienst
Partner - Champion III
Partner - Champion III

Hard to say - here are some ideas:

Complex calculation(s) with use of expensive calculation constructs like sum(if()) or aggr().

Expressions that span large tables that are incorrectly associated or not associated at all

Complex and unwanted synthetic key(s)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jyothish8807
Master II
Master II

Hi Saksham,

As Jon suggested one there could be couple of reasons.

1. Huge amount of data

2. Complex calculations

3. Bad data model

Also i would recommend you to check your RAM utilization at the same time, if it is reaching its limits then you have find a solution to optimize it.

Also i can see some tables on the load page, tables take more ram while loading. Try to create a welcome page with no charts on it and then do the load again.

Br,

KC

Best Regards,
KC
Anonymous
Not applicable
Author

Hi

Please can you provide with the solution for the same?

jyothish8807
Master II
Master II

Hi,

Please provide the below information:

1. qvw size

2. Amount of data loaded

3. Data model snapshot

4. Expression and dimension used in the tables

It is very difficult to identify the root cause with out seeing the actual qvw

Br,

KC

Best Regards,
KC
Anonymous
Not applicable
Author

data modelimage2.pngqvw size image3.pngexpression and dimensions

image4.png2016

=num(

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)),  [inv value]))/Sales_INR_Unit,

'#,##0.0') and so on.....

jyothish8807
Master II
Master II

Hi,

Issue seems to be your expressions. Try to avoid sum(if( expressions.

Use set analysis.

Br,

KC

Best Regards,
KC
Anonymous
Not applicable
Author

so how to covert this into proper set analysis expression?