Chart expression Vs Memory utilization

[amit_saini]

Hi Folks,

We are facing serious issue with server memory utilization, sometimes it is exceeding more than 100% and this leads to server machine crash.

Although we have restricted memory utilization from QMC max upto 80% of the total machine memory. Finally we found reason for this from the Audit log file of QlikView server that one of our application chart is causing this issue . When user trying to access this chart, it's not responding for 15-20 mints and during this time frame we can see  from the task manager that memory increasing from 20,30% upto 100% and crashing  server.

We are using below expression in chart :

Sum ({<Complaint_Acceptance-={4}>}QTY_PPM*Top_Pos_Flag)/
if(Complaint_Type=3 or Complaint_Type=1,  aggr(nodistinct Sum (QTY_Delivered_TOTAL), Month),
if(Complaint_Type=2 or Complaint_Type=7, aggr(nodistinct Sum (QTY_Received_TOTAL),Month),0))
*1000000

Please suggest what shall we do for this expression so that chart will respond in short period of time like other.

I tried this expression to get rid off aggr function , but output is not matching.

Sum ({<Complaint_Acceptance-={4}>}QTY_PPM*Top_Pos_Flag)/
sum(
if(match(Complaint_Type, 1, 3), QTY_Delivered_TOTAL, 
if(match(Complaint_Type, 2, 7), QTY_Received_TOTAL,
0))
)
*1000000

Thanks,

AS

[jagan]

Hi Amit,

Is this two columns QTY_PPM and Top_Pos_Flag are in same table or in different table?  If possible calculate (multiply) this in the script itself and check the performance.

Regards,

Jagan.

[amit_saini]

Also I just want to tell you , if I'm using either of the  expression alone without division  than charts are acting within seconds.

Only issue while doing "/" , which is strange to me.

Thanks,
AS

[amit_saini]

Hi Jagan,

Thanks for ur suggestion!

Both are in same table , i tried this approach too . Still same issue

Thanks,

AS

[jagan]

Hi Amit,

When you are calculating both the expressions separately are you getting this issue?

Expression1: Sum ({< Complaint_Acceptance-={4},Month=,Year=, Day=, Year_Month=, NumDate = {">=$(vRollingDate)<=$(vRollingDateEnd)"} >} QTY_PPM*Top_Pos_Flag)
Expression2: Sum ({<Complaint_Type={3,1},Month=,Year=, Day=, Year_Month=,  NumDate = {">=$(vRollingDate)<=$(vRollingDateEnd)"} >} QTY_Delivered_TOTAL)

OR try this

=(Sum ({< Complaint_Acceptance-={4},Month=,Year=, Day=, Year_Month=, NumDate = {">=$(vRollingDate)<=$(vRollingDateEnd)"} >} QTY_PPM*Top_Pos_Flag) /
Sum ({<Complaint_Type={3,1},Month=,Year=, Day=, Year_Month=,  NumDate = {">=$(vRollingDate)<=$(vRollingDateEnd)"} >} QTY_Delivered_TOTAL))*1000000

Regards,

Jagan.

[amit_saini]

Hi Jagan,

When I'm using them separately , no issue at all . The only problem when I'm using them together.

I tried your second suggestion too , still same issue.

But what I found is , if I'm converting this into Straight table instead of line chart then it is working fine.

Thanks,

AS

[jagan · Accepted solution]

Hi Amit,

Try creating the new object and check, sometimes it works.

Regards,

Jagan.

[amit_saini]

Hi Jagan,

It's really strange for me , but it is really working after creating new object. Is this bug in QlikView or something else???

Thanks a lot!

AS

[jagan]

Really strange, but sometimes it is happening like that, faced this lot of times.

Regards,

jagan.