topic Re: custom sort in QlikView

custom sort

QSense — Mon, 18 Jun 2012 07:23:24 GMT

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

Thanks

Re: custom sort

Mon, 18 Jun 2012 07:39:57 GMT

Hi,

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

Regards

Apurva

Re: custom sort

magavi_framsteg — Mon, 18 Jun 2012 07:46:02 GMT

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.

Re: custom sort

Tue, 31 Jul 2012 01:18:44 GMT

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

Re: custom sort

Tue, 31 Jul 2012 01:18:51 GMT

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

Re: custom sort

Tue, 31 Jul 2012 01:19:13 GMT

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

Re: custom sort

SunilChauhan — Tue, 31 Jul 2012 07:09:58 GMT

in charts properties ->sort->expression

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

fieldname which contain D A C B Z

hope this helps

Re: custom sort

ericcosmai — Tue, 31 Jul 2012 19:32:08 GMT

Hi...

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

Regards.

Re: custom sort

Thu, 27 Mar 2014 16:06:33 GMT

check this post for custom sorting options:

Qlikview Bitz and Pieces: Custom Sort in Qlikview

Re: custom sort

maxgro — Thu, 27 Mar 2014 22:39:31 GMT

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