custom sort

[QSense]

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

[#2]

Hi,

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

Regards

Apurva

[magavi_framsteg]

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.

[#4]

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

[#5]

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

[#6]

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]

in charts properties ->sort->expression

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

fieldname which contain D A C B Z

hope this helps

[ericcosmai]

Hi...

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

Regards.

[#9]

check this post for custom sorting options:

Qlikview Bitz and Pieces: Custom Sort in Qlikview

[maxgro]

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