Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

custom sort

Hi everyone

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

I mean

D

A

C

B

Z

Thanks

9 Replies
Not applicable

Hi,

you can use a function =dual('D',1) and so on for others in the script.

Regards

Apurva

magavi_framsteg
Partner - Creator III
Partner - Creator III

Hi qliekview.

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:

LOAD

FieldXX;

LEFT JOIN (YourTableWithRealValues)

LOAD * INLINE [

    FieldXX, SortOrder_FieldXX

    D, 1

    A, 2

    C, 3

    B, 4

    Z, 5

];

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Not applicable

Hi Magnus,

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?

Thanks

Not applicable

Hi Magnus,

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?

Thanks

Not applicable

Hi Magnus,

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?

Thanks

SunilChauhan
Champion
Champion

in charts properties ->sort->expression

wildmatch(fieldname,'D','A','C','B','Z')

fieldname which contain D A C B Z

hope this helps

Sunil Chauhan
ericcosmai
Contributor III
Contributor III

Hi...

If the question is where can you type the script... Go to File > Edit Script .... or just press Ctrl+E....

Regards.

Not applicable

check this post for custom sorting options:

Qlikview Bitz and Pieces: Custom Sort in Qlikview

maxgro
MVP
MVP

if you want D at the top and the other values disordered (in field F)

1.png