Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview Slider sort expression

Hello,

I have a table from where i am getting date and month (Jan,feb etc). I am showing the months in a slider. However, the slider is not showing the months in correct order. I wanted to sort this by using an expression and given each month a hardcoded value so that those hardcoded values are used for ordering rather than the value of months. However, the sort expression is disabled in the sort tab.

Can someone please help me how can i accomplish this customized sorting

Best Regards

Syed

3 Replies
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

is your Month a datefield resp. created from a datefield? Then it is dual and you can enter to sort numeric!

Not applicable
Author

Hello,

Since the month field is showing values in strings ('Jan', 'Feb' etc), therefore, this is a varchar field and i cannot sort it using numeric sort

br

Syed

Not applicable
Author

And yes, This value has been extracted from Date field, but inside Teradata, and once it is loaded into QV, it is already a varchar field

-br

Syed