qlikview link hangs with selection

[rdsuperlike]

Users are facing issue when they click on the filters for a particular tab through the URL/link/accesspoint. The link hangs up/freezes

But when I checked the same thing through the .qvw file it works fine.

What can be the issue here? How to troubleshoot?

thanks

[phaneendra_kunc]

Do you have access to QVS (Qlikview Server)? can you see how much RAM it is occupying when you open this app thru accesspoint.

It is odd that it hangs up on accesspoint but not on desktop. Assuming you are looking at same QVW file from access point and Desktop.

[Anonymous]

may be it setting problems like ram size is not sufficient

[rdsuperlike]

No I dont have access to Qlikview server. how do i see the size occupied through access point once i get the access

[phaneendra_kunc]

I would suggest you to do this on your qlikview desktop first and then see in server.

Desktop:

Open the QVW file and navigate to the Tab and make same selections that are getting the app hang.

go to task manager --> processes and see for your login id QV.exe's memory occupancy

Record the size.

Server:

You need remote desktop access to server (QVS).

Open the task manager --> processes and record memory occupancy of QVS.exe

now open accesspoint and open the app and go to the tab and make the selections that are getting the app hang.

monitor the QVS.exe on server side and it should spike up and see where it is?

i would recommend to do this on DEV box so that you don't have to worry about the active sessions, if it is PROD you can not predict as some one might be accessing other apps and that increases QVS.exe memory and you wont be able to get the true result.

Also make sure if your QVS has sufficient RAM to support this app.

[avinashelite]

Does all the users are facing this issue or only few users?? if its only few users then check the RAM availability in the user machine ..if your app size more than it might not have enough memory to open the document ... 

[rdsuperlike]

When i checked it on my local, the .exe has almost 2GB space occupied.

I see a lot of if statement in the expressions. Do you think chnaging them to set analysis would help better the performance.

I have below statement:

count(distinct if([Test Result Code] <> ' ' AND [Test Result Code] <> null(),[Serial Number]))

Below set analysis looks correct ?

count(distinct{$<[Test Result Code] -= {' ',null}>} [Serial Number] )

the xpression shows ok but it gives those red line...so not sure

[phaneendra_kunc]

That should work...u missed brackets with null() ...

count(distinct{$<[Test Result Code] -= {' ',null()}>} [Serial Number] )