topic Re: Date Sort in QlikView

Date Sort

nicogene — Mon, 22 Aug 2011 14:17:50 GMT

Hello,

I have a straight table in which i need to sort the date column but it does not work. I have already tried all possible settings in properties/sort. I can only sort the other columns.

Please find enclosed a screenshot of the table.

Thanks in advance

Regards,

Nicolas GENERE

Date Sort

Mon, 22 Aug 2011 14:23:08 GMT

I think you can do this by clicking in properties/classify and make your date column the first inr priority rank.

Date Sort

Or — Mon, 22 Aug 2011 14:29:44 GMT

Unfortunately, this screenshot isn't at all helpful in looking into your problem. You may want to include a sample QVW (with scrambled data if necessary).

Date Sort

Mon, 22 Aug 2011 14:31:41 GMT

Make sure that the date field is on top of the sort list and only select numeric value.

Regards,

Bert

Date Sort

Mon, 22 Aug 2011 19:30:07 GMT

Yes I agree with BERTDOOMEN,

I faced a similar situation, and all you need to do is make sure you promote your date field to the top of the sort list and then you can do ascending/descending of the numeric value.

Regards,

Bikash Debnath

Re: Date Sort

nicogene — Tue, 23 Aug 2011 16:04:43 GMT

Hello,

Thank you very much for you fast response.

Nevertheless, i have already tried this practice and my problem is always present.

Please find enclosed a QV file.

Best Regards,

Nicolas GENERE

Re: Date Sort

Tue, 23 Aug 2011 16:15:07 GMT

Hi,

I have attached the solution with this post. If this is ok, then let me know.

Regards,

Bikash

Re: Date Sort

nicogene — Tue, 23 Aug 2011 16:32:49 GMT

Hi,

Thanks

But, it's not possible to realise a sort on the date field.

For information, i have QlikView for Windows, Version 10.00.9055.7 SR3

Regards,

Nicolas GENERE

Re: Date Sort

Tue, 23 Aug 2011 16:35:00 GMT

Hi Nicolas,

I am afraid I haven't understand quite well what you are trying to explain.

Does the problem still persists? Could you please elaborate?

Regards,

Bikash

Re: Date Sort

Anonymous — Tue, 23 Aug 2011 16:44:05 GMT

Hi Nicolas,

What do you mean by "it's not possible to realise a sort on the date field."??

I tried bikashdebnath solution and the date sort is working.

If you want to have an interactive sort you have to check the box in the sort tab. like this you could sort in both way.

hope that will help you.

regards,

Arnaud

Re: Date Sort

nicogene — Tue, 23 Aug 2011 16:46:56 GMT

Sorry, yes the problem still persists.

I need to sort the date column but it does not work.

Regards,

Nicols GENERE

Re: Date Sort

Tue, 23 Aug 2011 16:52:33 GMT

Hi Nicolas,

The problem is your date field is used as a calculated dimension. So what I did in my attached application(above) is

put Identifiant into the calculated dimension and datefin as a normal dimension. But this will convert Datefin to Julian Date(number) format, so in edit dimension I changed it to date format by Date(Datefin).

Hope this helps,

Regards,

Bikash

Re: Date Sort

Anonymous — Tue, 23 Aug 2011 17:08:11 GMT

hi,

bikashdebnath is right. you cannot make a sort directly on your expression (or calculated dimension) in the sort tab.

In your case, you can only make a sort on dimensions fields.

Another way to do, if you don't want to move your field "datefin" in the dimension tab, is to put a sort by "datefin" on your dimension's fields

Exemple :

On the sort tab, put the field "Nom" at the top of the list and add an expression sort and use "dateFin".

Regards,

Arnaud

Re: Date Sort

stevedark — Tue, 23 Aug 2011 22:13:58 GMT

As suggested you can make Datefin a dimension - if you do this you will want to set the number format for the field to a Date in Settings \ Document Properties \ Number . You will also want to implement the colours by drilling on the Dimension and specifying an expression in the Background Colour dialog.

Alternatively, simply deleting the =RowNo(total) expression will allow it to sort fine. I presume that it is the fact this is an inter row function it overrides the correct sort functionality.

Hope that helps,

Steve