Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kristof_j
Contributor II

change load order

hi

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.

Tags (1)
11 Replies

Re: change load order

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

kristof_j
Contributor II

Re: change load order

I've uploaded a sample

vardhancse
Valued Contributor II

Re: change load order

Are you trying to transpose the rows to columns

Re: change load order

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

Not applicable

Re: change load order

Try using

Above(time,-1) - time

kristof_j
Contributor II

Re: change load order

I just load the csv and some preceding loads.

The csv is ordered but still the load order changes.

Employee
Employee

Re: change load order

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.

kristof_j
Contributor II

Re: change load order

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

Employee
Employee

Re: change load order

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.

Community Browser