Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you share more information? May be which field are you trying to change the load order for? Maybe share you script?
I've uploaded a sample
Are you trying to transpose the rows to columns
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
Try using
Above(time,-1) - time
I just load the csv and some preceding loads.
The csv is ordered but still the load order changes.
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.
That doesn't work if you add a dimension after the time dimension
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.