Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
beck_bakytbek
Honored Contributor

Sorting of dimensions

H Folks,

i got a Question, how can i sort the Dimension dynamically:

my Situation does look like: I have the Dimension: MonthYear within the Barchart and they do look like:

Dec 18, Jan 19, Mrc 19, Nov 18,

( i can sort them by using of function: Match (), for instance: Match ( Nov 18, Dec 18, Jan 18, Mrc 19) but this way of proceeding is Manual,

i would like to know whether it possible to sort These dimensions dynymically (in script area):

My  expected Output is: Nov 18, Dec 18, Jan 18, Mrc 19

 

Does anybody have any idea?

Thanks a lot Beck

Labels (1)
6 Replies
Partner
Partner

Re: Sorting of dimensions

Can u PLEASE share a sample app of urs with this bar chart?Thanks 🙂 

beck_bakytbek
Honored Contributor

Re: Sorting of dimensions

Hi Omar, thanks a lot for your responce, this is my example

 example.PNG

Partner
Partner

Re: Sorting of dimensions

How did u create ur Month field?
beck_bakytbek
Honored Contributor

Re: Sorting of dimensions

Hi Omar,

i created this Dimension by using of this function: Month(Dim1) & ' ' & Right(Year(Dim1),2) as MyDim

ramasaisaksoft
Valued Contributor III

Re: Sorting of dimensions

Hi Beck,

Internal sorting

Apart from setting the sorting order between dimensions and measures, you can also set the internal sorting order, under Sorting.

Click the dimension or measure name to open the settings and click the sorting button to switch to Custom sorting. The following table shows the internal sorting priority order and sorting options. The sorting is either Ascending or Descending.

Sorting options:

  • Sort by expression (Enter an expression to sort by. Only available for dimensions.)
  • Sort numerically
  • Sort alphabetically

Additionally, you can sort by load order by switching to Custom and leaving all sorting options un-selected.

If you have set a custom order for a field, that custom order will override any selected internal sort order in Sorting.

 

beck_bakytbek
Honored Contributor

Re: Sorting of dimensions

Hi Ramasaisaksoft,

 

thanks a lot for your responce, do you have an example?