Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi, QlikView community
I have a small problem that is not difficult to figure out.
But I have not figure it out yet.
Usually I want sort order to be in numeric value order or something similar.
But now I want to the sort order to be same no matter what.
How can I do that?
Hi
Please follow the below order of script for CUSTOM SORT.
Temp:
LOAD * Inline [
Category
Meat
Fish
Chicken
];
Data:
LOAD * INLINE [
Category,Sales
Fish,100
Meat,200
Chicken,450
DROP Table Temp;
Note:
Reload the script. Modify the properties of the Category list box and on the Sort tab,
set the Sort by option to Load Order.
View solution in original post
what do you mean you want it to be the same no matter hat?
I mean let say for example I have
Category Sales
Fish 100
Meat 200
Chicken 450
In qlikview I can have different sort order.
But I want have the order first Meat, second Fish and then Chicken
and I want that order to be same no matter what
i you always want it like this you have to load in you table in that order and then use the last possible sort method. i dont know what it is called in english but it should be something like load order
hope this helps.
regards,
MT
is it only possible to this in the script?
I can't do it in the chart properties -> sort?
yes you do this in the chart properties -> sord -> load order
the only think you have to do in your script is you have to change the order how you load you data.
Create an Inline load like:
Load
Category,
Autonumber() as SortOrder
Inline [
....
]; /// your desired order
Now use this SortOrder field in the osrt tab.
Hi Darri,
use this in sort tab expression
WildMatch(Category,'Meat','Fish','Chicken')
vipin
In Chart Properties Sort Tab
set to sort by Option to Load Order.
