topic Re: How do i arrange this date in order in QlikView

How do i arrange this date in order

Wed, 15 Oct 2014 19:25:54 GMT

Hello,

Plz help me arrange date in order Year, Month. Find attached

Regards

Ema

Re: How do i arrange this date in order

MK_QSL — Wed, 15 Oct 2014 20:18:41 GMT

Year and Month calculation section need to be corrected as below..

Year(Date#(TRIM(Date_promoted),'MMM D YYYY'))

and

Month(Date#(TRIM(Date_promoted),'MMM D YYYY'))

Re: How do i arrange this date in order

MarcoWedel — Wed, 15 Oct 2014 21:47:23 GMT

Hi,

=Date(Date#(Date_promoted,'MMM DD YYYY'),'YYYY/MMM')

hope this helps

regards

Marco

Re: How do i arrange this date in order

Wed, 15 Oct 2014 23:27:13 GMT

Hello Macro,

This helped alittle but worked for only promoted, how do i resolve the rest in the container?

Help

Re: How do i arrange this date in order

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

Hi,

this solution can be adapted to your other Timestamp fields as well:

hope this helps

regards

Marco

Re: How do i arrange this date in order

MarcoWedel — Thu, 16 Oct 2014 10:37:37 GMT

Hi Ema,

I noticed that you don't close your threads.

Please do so to help increase the readability and searchability of this forum.

Thanks

regards

Marco

Re: How do i arrange this date in order

ashfaq_haseeb — Thu, 16 Oct 2014 10:40:46 GMT

Hi,

did you check my reply here

http://community.qlik.com/thread/138053

Please don't post multiple threads.

and please close threads if you get required output.

Regards

ASHFAQ

Re: How do i arrange this date in order

Sun, 16 Nov 2014 19:20:32 GMT

Marco,

Plz remove snapshot.

Thanks

Re: How do i arrange this date in order

MarcoWedel — Sun, 16 Nov 2014 19:43:23 GMT

Emma,

Plz close your threads.

Thanks

Re: How do i arrange this date in order

Sun, 16 Nov 2014 22:16:37 GMT

Hello Macro,

i have plz remove pix

Re: Re: How do i arrange this date in order

ashfaq_haseeb — Mon, 17 Nov 2014 06:06:54 GMT

Hi,

Check this too.

Regards

ASHFAQ

Re: How do i arrange this date in order

Mon, 17 Nov 2014 07:27:55 GMT

Remove snapshot macro