Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

robhagat
New Contributor

QlikSenseBrowser has stopped working issue

Hi,

I am getting the following issue after opening the load editor. This is happening after using match function and also after many if else conditions are used for the same parameter field (PResponseTime).

Can you please suggest if this error is because of the  performance or something else is causing the same?

Issue with Qlik.png

Regards,

Romila

3 Replies
andrespa
Valued Contributor

Re: QlikSenseBrowser has stopped working issue

Hi Romila, probably you're running out the RAM memory of your pc, so for that particular transformation Qlik Sense needs more available and if you're out then the process is terminated (What's your RAM specs?). One suggestion I would give you is to change the logic and try not to use so many if conditions, try to use ApplyMaps.

Hope it helps,

Andrés

robhagat
New Contributor

Re: QlikSenseBrowser has stopped working issue

Hi Andres,

Thanks for the reply but I do not think there is issue because of RAM memory. Please see below screenshot of my system for your reference.

In my code I am trying to calculate the response time for a ticket created based on the SLA and the priority of the tickets. I have to consider holidays, weekends and the non-official hours. If any ticket is created during holidays, weekends and the non-official hours I have to calculate the response time of our team accordingly. I also have to carry forward the remaining time if ticket is created 5 minutes before the closure of business hours (17:30). Trying to implement the logic for these reasons.

Please see below the logic that I have implemented and trying to show in one column (PResponseTime). Is this error because of so many conditions that I am using in my code? Can you please suggest another approach for the below piece of code?

 

// ---------------* Ticket (Priority-1 and Priority-2) created on holiday *--------------------------------------------

 

If(Priority='Priority-1' or Priority='Priority-2' and Match(CreateDate, $(vHoliday)) and Match(Date(CreateDate+1, 'DD/MM/YYYY'), $(vHoliday)) and WeekDay(CreateDate+1) <> 'Fri', Timestamp#(Date(CreateDate+2) &' 10:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-1' or Priority='Priority-2' and Match(CreateDate, $(vHoliday)) and Match(Date(CreateDate+1, 'DD/MM/YYYY'), $(vHoliday)) and WeekDay(CreateDate+1) = 'Fri', Timestamp#(Date(CreateDate+5) &' 10:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-1' or Priority='Priority-2' and Match(CreateDate, $(vHoliday)) and Match(Date(CreateDate+3, 'DD/MM/YYYY'), $(vHoliday)) and WeekDay(CreateDate) = 'Fri', Timestamp#(Date(CreateDate+4) &' 10:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-1' or Priority='Priority-2' and Match(CreateDate, $(vHoliday)) and WeekDay(CreateDate) <> 'Fri', Timestamp#(Date(CreateDate+1) &' 10:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-1' or Priority='Priority-2' and Match(CreateDate, $(vHoliday)) and WeekDay(CreateDate) = 'Fri', Timestamp#(Date(CreateDate+3) &' 10:00', 'DD/MM/YYYY HH:mm'),

 

// --------------* Ticket (Priority-3 and Priority-4) created on holiday *--------------------------------------------

 

If(Priority='Priority-3' or Priority='Priority-4' and Match(CreateDate, $(vHoliday)) and Match(Date(CreateDate+1, 'DD/MM/YYYY'), $(vHoliday)) and WeekDay(CreateDate+1) <> 'Fri', Timestamp#(Date(CreateDate+2) &' 11:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-3' or Priority='Priority-4' and Match(CreateDate, $(vHoliday)) and Match(Date(CreateDate+1, 'DD/MM/YYYY'), $(vHoliday)) and WeekDay(CreateDate+1) = 'Fri', Timestamp#(Date(CreateDate+5) &' 11:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-3' or Priority='Priority-4' and Match(CreateDate, $(vHoliday)) and Match(Date(CreateDate+3, 'DD/MM/YYYY'), $(vHoliday)) and WeekDay(CreateDate) = 'Fri', Timestamp#(Date(CreateDate+4) &' 11:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-3' or Priority='Priority-4' and Match(CreateDate, $(vHoliday)) and WeekDay(CreateDate) <> 'Fri', Timestamp#(Date(CreateDate+1) &' 11:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-3' or Priority='Priority-4' and Match(CreateDate, $(vHoliday)) and WeekDay(CreateDate) = 'Fri', Timestamp#(Date(CreateDate+3) &' 11:00', 'DD/MM/YYYY HH:mm'),

 

// -------------------------* Ticket created before InTime *-------------------------------------------------

 

If(Priority='Priority-1' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') < Interval($(vInTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Sat' and WeekDay(CreateTimestamp) <> 'Sun', Timestamp#(CreateDate&' 10:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-2' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') < Interval($(vInTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Sat' and WeekDay(CreateTimestamp) <> 'Sun', Timestamp#(CreateDate&' 10:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-3' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') < Interval($(vInTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Sat' and WeekDay(CreateTimestamp) <> 'Sun', Timestamp#(CreateDate&' 11:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-4' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') < Interval($(vInTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Sat' and WeekDay(CreateTimestamp) <> 'Sun', Timestamp#(CreateDate&' 11:00', 'DD/MM/YYYY HH:mm'),

 

// ------------------------------* Ticket created after OutTime and not friday *------------------------------------

 

If(Priority='Priority-1' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Fri', Timestamp#(Date(CreateDate+1) &' 10:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-2' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Fri', Timestamp#(Date(CreateDate+1) &' 10:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-3' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Fri', Timestamp#(Date(CreateDate+1) &' 11:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-4' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) <> 'Fri', Timestamp#(Date(CreateDate+1) &' 11:00', 'DD/MM/YYYY HH:mm'),

 

// --------------------* Ticket created after OutTime on friday *-----------------------------------------

 

If(Priority='Priority-1' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) = 'Fri', Timestamp#(Date(CreateDate+3) &' 10:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-2' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) = 'Fri', Timestamp#(Date(CreateDate+3) &' 10:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-3' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) = 'Fri', Timestamp#(Date(CreateDate+3) &' 11:00', 'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-4' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') > Interval($(vOutTime),'HH:mm') and WeekDay(CreateTimestamp) = 'Fri', Timestamp#(Date(CreateDate+3) &' 11:00', 'DD/MM/YYYY HH:mm'),

 

// -----------------* Ticket created after InTime and before OutTime (within the SLA time) *------------------

 

If(Priority='Priority-1' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') >= Interval($(vInTime),'HH:mm') and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') <= Interval($(vOutTime),'HH:mm') and Time(Interval($(vOutTime)-CreateTime), 'h:mm') > Time#('1', 'h:mm'),TimeStamp(Num(CreateTimestamp)+(1/24),'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-2' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') >= Interval($(vInTime),'HH:mm') and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') <= Interval($(vOutTime),'HH:mm') and Time(Interval($(vOutTime)-CreateTime), 'h:mm') > Time#('1', 'h:mm'),TimeStamp(Num(CreateTimestamp)+(1/24),'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-3' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') >= Interval($(vInTime),'HH:mm') and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') <= Interval($(vOutTime),'HH:mm') and Time(Interval($(vOutTime)-CreateTime), 'h:mm') > Time#('2', 'h:mm'),TimeStamp(Num(CreateTimestamp)+(1/12),'DD/MM/YYYY HH:mm'),

 

If(Priority='Priority-4' and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') >= Interval($(vInTime),'HH:mm') and Interval#(Time(CreateTimestamp,'HH:mm'),'HH:mm') <= Interval($(vOutTime),'HH:mm') and Time(Interval($(vOutTime)-CreateTime), 'h:mm') > Time#('2', 'h:mm'),TimeStamp(Num(CreateTimestamp)+(1/12),'DD/MM/YYYY HH:mm'),

  'NA')))))))))))))))))))))))))) as PResponseTime

QlikCode.png

Regards,

Romila.

robhagat
New Contributor

Re: QlikSenseBrowser has stopped working issue

Hi,

Can anyone please help me in this, I am really stuck and not able to proceed with my work?

Waiting for suggestions.

Regards,

Romila.