Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Hi Jagan,
Thanks for ur suggestion!
Both are in same table , i tried this approach too . Still same issue
Thanks,
AS
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.
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
Hi Amit,
Try creating the new object and check, sometimes it works.
Regards,
Jagan.
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
Really strange, but sometimes it is happening like that, faced this lot of times.
Regards,
jagan.