Qlikview Slider sort expression

[#1]

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

[brenner_martina]

Hi,

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

[#3]

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

[#4]

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