2 Replies Latest reply: Feb 3, 2017 7:16 AM by Alvaro Urien Ayala RSS

    Qlik Sense Engine getting stopped

    bandhu Gupta

      I created a Dashboard in Qlik Sense and used Auto Calender as shown below . It's working for the first time . While creating app , i have used this AutoCalender property as well . Also to keep some fields with similar name to be treated as different , i used Qualify and unqualify as well.

       

      At the first time when i open this sheet , it gives the correct visualization and everything runs perfect but after some time , when i reopen the sheet , some of the components didn't get loaded properly and keep on rolling and in another 5-10 sec , it shows the error as

       

       

      "No available Qlik Sense engine was found . Refresh your browser or contact your system administrator"

       

       

      Which finally stops the Engine and get automatically started after few seconds . Similar message is shown on all the open screen.

       

       

      [autoCalendar]:

      DECLARE FIELD DEFINITION Tagged ('$date')

      FIELDS

      Dual(Year($1), YearStart($1)) AS [Year] Tagged ('$axis', '$year'),

      Dual('Q'&Num(Ceil(Num(Month($1))/3)),Num(Ceil(NUM(Month($1))/3),00)) AS [Quarter] Tagged ('$quarter'),

       

       

       

       

      Dual(Year($1)&'-Q'&Num(Ceil(Num(Month($1))/3)),QuarterStart($1)) AS [YearQuarter] Tagged ('$axis', '$yearquarter'),

      Month($1) AS [Month] Tagged ('$month'),

      Dual(Year($1)&'-'&Month($1), monthstart($1)) AS [YearMonth] Tagged ('$axis', '$yearmonth'),

      Dual('W'&Num(Week($1),00), Num(Week($1),00)) AS [Week] Tagged ('$weeknumber'),

      Date(Floor($1)) AS [Date] Tagged ('$date');

       

       

      DERIVE FIELDS FROM FIELDS [regionfs.rfs_date] USING [autoCalendar] ;

       

      Please suggest