change load order

[kristof_j]

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.

[sunny_talwar]

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

[kristof_j]

I've uploaded a sample

[vardhancse]

Are you trying to transpose the rows to columns

[sunny_talwar]

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

[#6]

Try using

Above(time,-1) - time

[kristof_j]

I just load the csv and some preceding loads.

The csv is ordered but still the load order changes.

[Luis_Cortizo]

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]

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

[Luis_Cortizo]

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.