Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

qliekview
Contributor 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

Re: custom sort

Hi,

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

Regards

Apurva

magavi_framsteg
Contributor III

Re: custom sort

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

Re: custom sort

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

Re: custom sort

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

Re: custom sort

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

chauhans85
Esteemed Contributor

Re: custom sort

in charts properties ->sort->expression

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

fieldname which contain D A C B Z

hope this helps

ericcosmai
New Contributor III

Re: custom sort

Hi...

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

Regards.

Not applicable

Re: custom sort

check this post for custom sorting options:

Qlikview Bitz and Pieces: Custom Sort in Qlikview

MVP
MVP

Re: custom sort

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

1.png

Community Browser