topic Re: Load Priority Order in QlikView

Load Priority Order

Anonymous — Mon, 21 Aug 2017 12:15:18 GMT

Hi all,

is it possible to specify a load priority order of tables?

I have three tables in one sheet and two of them take under a second to calculate/load while the third takes about 20 seconds.

At the moment the third table is calculated / loaded first. The other two tables can't be calculated until Qlikview has finished the calculations of the third table.

Is it possible to prioritize the calculation of the first two tables?

Thanks in advance,

Vic

Re: Load Priority Order

vishsaggi — Mon, 21 Aug 2017 16:15:56 GMT

I am not sure if that is possible... Can you elaborate a little with some sample data?

Re: Load Priority Order

Anonymous — Tue, 22 Aug 2017 06:17:52 GMT

I don't have access to Qlikview right now, but simply put:

1) I have 3 tables.

2) I want to specify which table gets calculated first.

Re: Load Priority Order

Anonymous — Tue, 22 Aug 2017 06:19:45 GMT

Also: The tables are not dependent on each other. They simply happen to be on the same sheet. So the calculation order does not matter from a technical perspective. But I'd like to give my users the chance to study the results of the two "fast-calculated" tables while the third one still calculates.

Re: Load Priority Order

marcus_sommer — Tue, 22 Aug 2017 11:00:49 GMT

The generell execution-order within the script is from top to bottom and from left to right (exeptions are preceeding loads and sub-routines). This meant you could just use cut & paste of your load-statements to change their execution-order.

- Marcus

Re: Load Priority Order

Clever_Anjos — Tue, 22 Aug 2017 11:01:45 GMT

It´s not possible to do that.

You can put a button that enables a variable that could be used into 3rd table to only be calculated when the user clicks into that button

Re: Load Priority Order

Anonymous — Tue, 22 Aug 2017 12:36:38 GMT

alright, thanks!