Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner
Partner

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
Partner
Partner

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)

Partner
Partner

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)

Partner
Partner

Re: Custom sort?

did you try checking numeric & Alphabetic to ascending order?

Partner
Partner

Re: Custom sort?

yes i tried,

it is not working

Partner
Partner

Re: Custom sort?

can you share sample app?

Partner
Partner

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')




Partner
Partner

Re: Custom sort?

Check