Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pascos88
Contributor

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
MVP
MVP

Re: Sorting By date qlik sense

Seem to making heavy weather of a small problem.

=Date(The_Date, 'MMM dd')


And sort it numerically

11 Replies
b_knuever
Contributor III

Re: Sorting By date qlik sense

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
Honored Contributor II

Re: Sorting By date qlik sense

why are you using Month&Day as dimension value ?

are you sure you don't need also Year ?

b_knuever
Contributor III

Re: Sorting By date qlik sense

He might filter on this year only already.

pascos88
Contributor

Re: Sorting By date qlik sense

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

pascos88
Contributor

Re: Sorting By date qlik sense

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

Thanks

agigliotti
Honored Contributor II

Re: Sorting By date qlik sense

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
Contributor

Re: Sorting By date qlik sense

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
Contributor

Re: Sorting By date qlik sense

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
Contributor

Re: Sorting By date qlik sense

No body have an idea about it?

Community Browser