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: 
pascos88
Creator II
Creator II

Sorting By date qlik sense

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

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Seem to making heavy weather of a small problem.

=Date(The_Date, 'MMM dd')


And sort it numerically

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

11 Replies
bramkn
Partner - Specialist
Partner - Specialist

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
Partner - Champion
Partner - Champion

why are you using Month&Day as dimension value ?

are you sure you don't need also Year ?

bramkn
Partner - Specialist
Partner - Specialist

He might filter on this year only already.

pascos88
Creator II
Creator II
Author

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

pascos88
Creator II
Creator II
Author

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

Thanks

agigliotti
Partner - Champion
Partner - Champion

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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

No body have an idea about it?