Sorting By date qlik sense

[pascos88]

Hi Gays how I can sort by date?

How You can see in the picture, I am not able to sotr by date, someone can suggest me some expression or how I can do it?

I have 1 dimension and 2 expressions that are a count of a value.

Thanks for any helps

[bramkn]

why the '' in the middle? This isn't needed. You can create a dual() in which you put the Num of the month and day as the number which you can use to sort.

[agigliotti]

why are you using Month&Day as dimension value ?

are you sure you don't need also Year ?

[bramkn]

He might filter on this year only already.

[pascos88]

Sorry but I dont need year, I have to compare value from different years

[pascos88]

Could you please give me an example of it? I will appreciate..

Thanks

[agigliotti]

if you just selected a Year you can use the below expression on Sorting dimension section:

check "Sort by expression" and type "The_Date" plus Ascending order.

[pascos88]

The problem is that if I use the year, the data that I need to compere it will show not in the right way. I mean if I have value X with data 02.02.2016 an value y with data 02.02.2017 I would see the two bar on the same day and month in order to compare.

Hope that you understand what I mean

[pascos88]

Hi Bram, If I change the expression as :

=Month(The_Date)+ day(The_Date) I have the data as a Number format.. Now maybe I need just to see the correct format of the data, and I think that the sort will work..

Any suggestions?

[pascos88]

No body have an idea about it?