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.
peha07ad
New Contributor II

How to partly load "section access"

Hi

I have time consuming Qlik sense data load which consists of a section app and a section access where the app takes by far the longest to load.

At the moment, I have to load both in order to just update the section access

Can I somehow "partly" load the section access only?

Br.,

Peter

6 Replies
MVP & Luminary
MVP & Luminary

Re: How to partly load "section access"

Normally the section access data are quite small and their load-times shouldn't be really noticing. Therefore I assume that you load the data from a database or from an active directory respectively LDAP which returned the data only slowly. To solve this you could add an intermediate step and storing these data into a qvd and then your read your section access from  the qvd (you will need an additionally where-clause for the qvd-load like: where 1=1 thereby the data will be processed and not simply transferred into the RAM).

- Marcus

peha07ad
New Contributor II

Re: How to partly load "section access"

Hi Marcus

thanks for your reply

The problem, however, is not a slow section access load.

The problem is that i have to load BOTH the section app and the section access when i load data. I want to load section access only.

MVP & Luminary
MVP & Luminary

Re: How to partly load "section access"

You could try it with a partial load: Partial Reload Easy and Simple whereby I'm not sure if it will work by section access tables. Another way could be to use multiple layer for your application and your final application (with the gui) is loading only qvd's created from the previous layer or from there a qvw per binary and your section access part will be added only in the final application.

- Marcus

stigchel
Honored Contributor

Re: How to partly load "section access"

My experience is limited to qlikview, but I found something that can maybe help you. From my qlikview experience you can (and need to) partial load the section access AND the fields you are reducing data on from the section application (qlikview example below). However, there seems to be no partial reload button in Qlik Sense, but I did find this to maybe resolve that (?)


Qlik Sense Partial Reload for v2.0.x and v2.1.1



Section Access;

Replace LOAD [ACCESS],

  NTNAME,

  ACCESSGROUP

FROM ...

Section Application;

star is *;

Replace LOAD  ACCESSGROUP

FROM ...

MVP & Luminary
MVP & Luminary

Re: How to partly load "section access"

Now I see that's a Sense topic and not QlikView but maybe the approach with a binary-load might still work by adapting it from: Qlik Sense substitute for BINARY load.

- Marcus

peha07ad
New Contributor II

Re: How to partly load "section access"

Thank you Piet Hein (which, incidentally is the name of famous Danish designer) and Marcus.

Thank you for your great suggestions. Due to Segregation of Duties at my company, I'm not allowed writing capabilities on the server (running Enterprise). I'll keep digging (or hold out for an update)

Br.,

Peter