topic Re: Sort graph by date in QlikView

Sort graph by date

sergio0592 — Tue, 19 Jul 2016 13:11:20 GMT

Hi all,

I have a line graphe with date value in abscissa. I have three lines, one per year and my date field is formatting with Oracle to_char function (to_char(Date_field,'DD/MM') . So, i expect 01/01, 02/01, 03/01.... 31/12.

I have even tried to sort with expression match(Date_field, '01/01',02/01','03/01'...'31/12'). Usually match() function works but not in this case!! Is there a way to achive that??

Re: Sort graph by date

sunny_talwar — Tue, 19 Jul 2016 16:51:12 GMT

Try this as your calculated dimension:

Date#(Date_field, 'DD/MM')

or use it as your sort expression with existing dimension:

Date#(Date_field, 'DD/MM')

Re: Sort graph by date

sergio0592 — Wed, 20 Jul 2016 06:52:35 GMT

Thanks Sunny, first issue works perfectly!

Re: Sort graph by date

oknotsen — Wed, 20 Jul 2016 07:53:16 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .