Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik Sense crashes in Load Editor

My data load runs well and my application works.

However, if I try to edit the data load the editor screen blanks, and closing this app closes Qlik Sense.

I'm using Qlik Sense Desktop 3.1

I've tried re-loading Qlik Sense - repair - without success.

Suggestions welcome.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi, Dillon,

I believe we've settled this problem!

In my data load I had a long series of (quite straightforward) "if" statements applied to an Excel table.  These were along the lines of

if(

    [Element] = '40402' or

    [Element] = '40403' or

    [Element] = '40404' or

    [Element] = '40405' or

    [Element] = '40407' or

    [Element] = '40410' or ...

(and so on for 40 or so elements)

...

   [Element] = '61013',

    'Primary',

and other, similar stuff until

...

    as [Rate],

I have now found the Debug button, which has allowed me to open my data load screen.  I realised that I was asking Qlik to update what was in effect a static (lookup) Excel table on the fly by creating a new column in the load.  I deleted that section of code, and the load worked.  (Then, as I should have done in the first place, I updated the Excel table with the lookup values and simply asked Qlik to import the field.)

Unfortunately, when I first set up this import there had been no problem with the load; I applied it to another six apps.  I now have to fix them - though now I know where the fault is, I can do that quite quickly.

Sorry to waste your time!

Regards,

Steve

View solution in original post

26 Replies
marcohadiyanto
Partner - Specialist
Partner - Specialist

Hi Steve,

Try to duplicate your file (qvf) and try it again.

Regards

Anonymous
Not applicable
Author

Good idea, thanks Marco.

Following another post I've uninstalled Qlik Sense, and checked for entries in the PC Registry.

Now I've reinstalled as administrator, and I'll see if there's an improvement.

Thank you for your response.

OK: reinstalling didn't help.

I've duplicated the app, and opened the replacement.  In data load editor I can click the "Load data" button, and the data loads without difficulty - no peculiarities at all.  But then if I click in the load script - or even just leave the load script sheet open - the page changes to a blank white screen.  The desktop hub does, too.

Steve

lakshmikandh
Specialist II
Specialist II

instead of accessing the Desktop application , try working with qliksense using "localhost:4848/hub" in the browser

Anonymous
Not applicable
Author

Have you tried create new apps and copy the script into new apps?

worth to try i think

marcohadiyanto
Partner - Specialist
Partner - Specialist

Hi Steve,

I got confused what do you mean load script? because you can open data load editor and you can load data.

can you share screenshot of your steps?

Thanks

Marco

Anonymous
Not applicable
Author

Thanks, Lakshmikandh; I'll give that a try.

Thanks, Ryan; I can't keep the load script open long enough to work on it!

Thanks, Marco;

Here are the steps:

  1. Open the application,
  2. Select an app - usually the one I particularly need to change - and click its icon
  3. Select "Data load editor".
  4. The editor opens:
  5. Note that from here I can click "Load data", and the data load runs perfectly.
  6. I want to edit "Table load".  (I've done this many times successfully.  So: click "Table load".
  7. Table load usually opens, though sometimes only the first  5 or 10 lines of code show at first.
  8. Now I either pause to gather my thoughts, or click the screen, or scroll down.  After about 10 seconds I get this (Note that I had to add a border to this image - because that's all there is!):
  9. If I click the X to close this app then Qlik Sense closes.

Thanks for any help - I'd like to get some work done, and this is preventing any progress!

Steve

Adding to this:

A colleague has Qlik Sense Desktop V3.0 SR2.  On her PC I can open my apps and edit them at will.

My PC has Qlik Sense V3.1 SP3, and while I can open and view the application, and make changes to the visualisations if necessary, I can't edit the data load (as above).

In both cases we are using exactly the same app, dragged and dropped from a network location.

So: the variables appear to be

  1. The specific PC being used, and
  2. The version of Qlik Sense Desktop.

Her PC is slightly newer than mine, but they both use the same OS (Windows 7), antivirus and so on, and are maintained by our facility's IT department under strict control.


marcohadiyanto
Partner - Specialist
Partner - Specialist

Hi Steve,

It never happened to me, but next time when white screen appear don't click X just press F5 (to refresh layout).

Hi mto‌‌,

can you help this?

Thanks

Marco

Michael_Tarallo
Employee
Employee

Hi Guys - can you try the latest SR 3. Let me know. - if it still occurs I will raise this with the products team.

Customers and partner can get it from our download site - or you can get Desktop here:Download Free Data Visualization Development Platform

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is usel to otheegards,

Mike Tarallo (@mtarallo) | https://twitter.com/mtarallo

Qlik

Regards,
Mike Tarallo
Qlik
Anonymous
Not applicable
Author

Thanks, Marco and Mike,

I uninstalled Qlik Sense, and re-downloaded V3.1 SP3 from the link you provided.

I have the same problem as above - the screen blanks after about 10 (sometimes more) seconds.

I used F5 to refresh the layout, and the screen rebuilt, and then again blanked after 10 or so seconds, as before.

Is it possible to download V3.0?  This works on a colleague's PC, and might eliminate my specific PC as contributing to the problem.

Thanks!

Steve