Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think you can do this by clicking in properties/classify and make your date column the first inr priority rank.
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).
Make sure that the date field is on top of the sort list and only select numeric value.
Regards,
Bert
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
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
Hi,
I have attached the solution with this post. If this is ok, then let me know.
Regards,
Bikash
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
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
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