3 Replies Latest reply: Mar 24, 2017 8:10 AM by Romila Bhagat RSS

    QlikSenseBrowser has stopped working issue

    Romila Bhagat

      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

        • Re: QlikSenseBrowser has stopped working issue
          Andres Prado

          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

            • Re: QlikSenseBrowser has stopped working issue
              Romila Bhagat

              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.

            • Re: QlikSenseBrowser has stopped working issue
              Romila Bhagat

              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.