topic Re: change load order in QlikView

change load order

kristof_j — Wed, 12 Aug 2015 09:35:55 GMT

Is there a way to change the load order?

I wanted to use the above() function but the results weren't what I expected.

Even if I sorted the csv like I wanted, there were still some records where de load order was different.

Re: change load order

sunny_talwar — Wed, 12 Aug 2015 09:37:58 GMT

Can you share more information? May be which field are you trying to change the load order for? Maybe share you script?

Re: change load order

kristof_j — Wed, 12 Aug 2015 09:49:04 GMT

I've uploaded a sample

Re: change load order

vardhancse — Wed, 12 Aug 2015 10:01:13 GMT

Are you trying to transpose the rows to columns

Re: change load order

sunny_talwar — Wed, 12 Aug 2015 10:02:20 GMT

Can you share your input in a Excel file as I am working on a Personal Edition of QlikView and won't be able to open the qvw you have attached.

Best,

Sunny

Re: change load order

Wed, 12 Aug 2015 10:09:20 GMT

Try using

Above(time,-1) - time

Re: change load order

kristof_j — Wed, 12 Aug 2015 10:36:54 GMT

I just load the csv and some preceding loads.

The csv is ordered but still the load order changes.

Re: change load order

Luis_Cortizo — Wed, 12 Aug 2015 10:38:44 GMT

Hi, Kristof

The most straightforward way of controlling the load order in QlikView is to define it yourself.

Let's say you're loading this sample table:

SampleTable:

LOAD

Field1,

Field2,

City

FROM [...]

To control de load order of the values on the City field what I'd is to load an inline (or a file source) table before that load as:

CityOrder:

Load * inline

[

City

CityA

CityB

CityC

];

SampleTable:

LOAD

Field1,

Field2,

City

FROM [...]

Drop Table CityOrder;

When the data information table (SampleTable) is being loaded the city load order is already defined by the CityOrder and QlikView will keep that order even when you drop the CityOrder table at the end of the script (the load order is store in-memory).

Hope it helps.

Best regards.

Re: change load order

kristof_j — Wed, 12 Aug 2015 10:43:15 GMT

That doesn't work if you add a dimension after the time dimension

Re: change load order

Luis_Cortizo — Wed, 12 Aug 2015 10:47:46 GMT

For what I can see on your app, what's exactly wrong on the load order.

Are you referring to the "time on page" expression order?

For what I see the dimensions are ordered correctly.

Re: change load order

kristof_j — Wed, 12 Aug 2015 10:59:07 GMT

That could work.

Is there a way to create a list with all seconds in 24h 🙂

Re: change load order

Luis_Cortizo — Wed, 12 Aug 2015 11:52:45 GMT

Do you mean create all the time stamps of 24 hours?

Off the top of my head you could do something like:

SET vL.Hours = 0;

SET vL.Minutes = 0;

SET vL.Seconds = 0;

TimeTable:

LOAD * INLINE [Time];

for k=0 to 23

SET vL.Minutes = 0;

for j = 0 to 59

SET vL.Seconds = 0;

for i = 0 to 59

concatenate (TimeTable) LOAD MakeTime($(vL.Hours), $(vL.Minutes), $(vL.Seconds)) as Time AutoGenerate 1;

LET vL.Seconds = $(vL.Seconds) + 1;

LET vL.Minutes = $(vL.Minutes) + 1;

LET vL.Hours = $(vL.Hours) + 1;

SET vL.Hours =;

SET vL.Minutes =;

SET vL.Seconds =;

SET i=;

SET j=;

SET k=;

Probable not the most efficient way to do it as it needs to concatenate 86400 load statements of one record, but it's easy and has a low load time

Hope it helps.

Best regards.