Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort Bar graph

Hi All,

I am trying to sort the bar graph, but i didn't get the way to sort in the below screen shot.

We actually get this based on composite field (Querter and Year).

Quarter Sort.JPG.

Need your support.

Thanks

UMAMAHESWRA REDDY

1 Solution

Accepted Solutions
sunny_talwar

May be like this:

Date#(KeepChar(Quarter, '0123456789'), 'MYYYY')

View solution in original post

7 Replies
Chanty4u
MVP
MVP

am not sure,

Try with Match function  in sort tab expression:

=match(Field,' value1','value2') 

shraddha_g
Partner - Master III
Partner - Master III

Use QuarterStart Field or QuarterStart(DateField) in Sort by Expression

sunny_talwar

May be like this:

Date#(KeepChar(Quarter, '0123456789'), 'MYYYY')

ganeshsvm
Creator II
Creator II

Best practice is, you should assign PeriodID using Dual() in your Composite field in backend script, This will be useful in sorting & also Date range calculations in the frontend.

something like this,

Dual(Quarter&' '&Year,AutoNumber(Quarter&' '&Year)) as QtrYrPeriod

Regards,

Ganesh

Not applicable
Author

Hi Chanty,

i tried that match, wild match as well, it is giving like below, i need year wise sort then quarter wise sort

1.JPG

shraddha_g
Partner - Master III
Partner - Master III

These are dynamic values You cant hardcode using Match()

Not applicable
Author

Hi Sunny,

thanks its working.