topic Re: Arrange date in order in QlikView

Arrange date in order

Thu, 16 Oct 2014 08:17:37 GMT

Hello,

Please somebody help in arranging date in order 'Year and Month'.

Find attached

Re: Arrange date in order

Thu, 16 Oct 2014 08:25:09 GMT

Anyone here to help??

Re: Arrange date in order

anbu1984 — Thu, 16 Oct 2014 08:34:13 GMT

Can you explain your requirement with expected output

Re: Arrange date in order

jonathandienst — Thu, 16 Oct 2014 08:34:36 GMT

You are more likely to get a response if you load the data into a qvw file and create the object for which you require sorting (and reduce the size - you only need a few 100 rows).

Jonathan

Re: Arrange date in order

Thu, 16 Oct 2014 08:34:53 GMT

Hiii,

Use Dual Function to Arrange Date in Order like:-

If(Month='Jan',dual('Jan',1),

If(Month='Feb',dual('Feb',2),

If(Month='Mar',dual('Mar',3),

If(Month='Apr',dual('Apr',4),

If(Month='May',dual('May',5),

If(Month='Jun',dual('Jun',6),

If(Month='Jul',dual('Jul',7),

If(Month='Aug',dual('Aug',8),

If(Month='Sep',dual('Sep',9),

If(Month='Oct',dual('Oct',10),

If(Month='Nov',dual('Nov',11),

If(Month='Dec',dual('Dec',12)

)))))))))))) as Month

Thanks & Regards

Prince Anand

Re: Arrange date in order

ashfaq_haseeb — Thu, 16 Oct 2014 08:52:06 GMT

Hi,

I did this for retirement date.

You can do the same for hire date

Regards

ASHFAQ

Re: Arrange date in order

MarcoWedel — Thu, 16 Oct 2014 10:40:27 GMT

Hi,

maybe this thread helps also:

How do i arrange this date in order

regards

Marco

Re: Arrange date in order

Mon, 17 Nov 2014 08:27:36 GMT

Ashfaq,

Is it possible to select by Year when it is in tree format? This what i want to achieve