Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

gauravgg
New Contributor III

Custom sort?

Hi all

I have a field as follows

PricePointer

17-Budget

18-Budget

17-Sept

17-May

16-Budget

17-Opening

17-Colsing

I want to custom sort this on x axis

16-Budget

17-Budget

17-Opening

17-Closing

17-Sept

17-May

18-Budget

Can anyone help me

thanks in Advance

Tags (2)
8 Replies
shraddha_g
Honored Contributor III

Re: Custom sort?

In sort by Expression

Try,

pick(wildmatch(PricePointer,

'16-Budget',

'17-Budget',

'17-Opening',

'17-Closing',

'17-Sept',

'17-May',

'18-Budget'),1,2,3,4,5,6,7)

gauravgg
New Contributor III

Re: Custom sort?

Hi Shraddha

but this sort should be dynamic

it should sort by Year  then the order should bb Budget ,Opening,Closing,and within months it sholud sort by Month(As jan to Dec in order)

shraddha_g
Honored Contributor III

Re: Custom sort?

did you try checking numeric & Alphabetic to ascending order?

gauravgg
New Contributor III

Re: Custom sort?

yes i tried,

it is not working

shraddha_g
Honored Contributor III

Re: Custom sort?

can you share sample app?

gauravgg
New Contributor III

Re: Custom sort?

no ,it's on server

I do not have rights

vinieme12
Esteemed Contributor II

Re: Custom sort?

Two Options either sort by expression using Match(  or create a sortOrder for this field in script

Option1: example

PricePointer_SortOrder:

LOAD * INLINE [

PricePointer, PP_SprtOrder

16-Budget,1

17-Budget,2

17-Opening,3

17-Closing,4

17-Sept,5

17-May,6

18-Budget,7

];

Then in Chart use sort by expression and add  =PP_SprtOrder




Option 2:

Sort by Expression

=Match(PricePointer,

'16-Budget',

'17-Budget',

'17-Opening',

'17-Closing',

'17-Sept',

'17-May',

'18-Budget')




shraddha_g
Honored Contributor III

Re: Custom sort?

Check

Community Browser