Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a list and I want to sort them custom for instance values are A,B,C,D....
I make D value top value and other values' sort are not important they can be disordered
you can use a function =dual('D',1) and so on for others in the script.
You can create a table with the sort order you want, and join it to your data model.
Then have the object (list box, table, multi box etc.) sort on the field SortOrder
YourTableWithRealValues:LOADFieldXX;LEFT JOIN (YourTableWithRealValues)LOAD * INLINE [ FieldXX, SortOrder_FieldXX D, 1 A, 2 C, 3 B, 4 Z, 5];
LEFT JOIN (YourTableWithRealValues)
LOAD * INLINE [
Framsteg Business Intelligence Corp.
I am new to qlikview and right now I am using the free personal edition to see what this system can do.
I have the same question as the original poster.
I do not know where to place the code you wrote above. Can you provide the detail steps on how to use it?
in charts properties ->sort->expression
fieldname which contain D A C B Z
hope this helps
If the question is where can you type the script... Go to File > Edit Script .... or just press Ctrl+E....
check this post for custom sorting options:
Qlikview Bitz and Pieces: Custom Sort in Qlikview
if you want D at the top and the other values disordered (in field F)