Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
dadadadadada
Contributor II
Contributor II

Minichart sorting in Table

hi!

When I am using Minichart in Straight table, with Month as Dimension, the data is not sorted correctly. I found no setting for the sort order inside Minichart. 

Is there way to correct this?

dadadadadada_0-1594927678305.png

 

Thank you!

Labels (1)
1 Solution

Accepted Solutions
dadadadadada
Contributor II
Contributor II
Author

it seems that Minicharts are sorted numerically by default.

So i solved this in the script by applying DUAL to all date fields:

DUAL( Month( Date )&'-'&Date( Date ,'YY' ), num( MonthStart( Date )) ) as MonthYear

View solution in original post

3 Replies
raji6763
Creator II
Creator II

Hi @dadadadadada ,

Try this

you can customize you sort order based on that the value you provide

Go to Sorting->Sort by expression->

match(Your field name,'values1',value2')

 

example :

Match(Month,'Jan-19','Feb-19''Mar-19',.......)

note :match function values  should be case sensitive

 

Regards,

raji

 

dadadadadada
Contributor II
Contributor II
Author

thanks, Raji

 

In real life it is not doable - my Dimension is Dynamic (Month, Week, Date, Year and etc.). I'd spend half day sorting this in formula with multiple IFs.

Also Minicharts can'be sorted by expression

dadadadadada_0-1594991892284.png

 

 

dadadadadada
Contributor II
Contributor II
Author

it seems that Minicharts are sorted numerically by default.

So i solved this in the script by applying DUAL to all date fields:

DUAL( Month( Date )&'-'&Date( Date ,'YY' ), num( MonthStart( Date )) ) as MonthYear