Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
steveh_nz
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
steveh_nz
Not applicable

Re: Qlik Sense crashes in Load Editor

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

26 Replies
chooco_co
Not applicable

Re: Qlik Sense crashes in Load Editor

Hi Steve,

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

Regards

steveh_nz
Not applicable

Re: Qlik Sense crashes in Load Editor

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
Not applicable

Re: Qlik Sense crashes in Load Editor

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

ryan_thomas
Not applicable

Re: Qlik Sense crashes in Load Editor

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

worth to try i think

chooco_co
Not applicable

Re: Qlik Sense crashes in Load Editor

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

steveh_nz
Not applicable

Re: Qlik Sense crashes in Load Editor

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.


chooco_co
Not applicable

Re: Qlik Sense crashes in Load Editor

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
Not applicable

Re: Qlik Sense crashes in Load Editor

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
steveh_nz
Not applicable

Re: Qlik Sense crashes in Load Editor

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