topic left in script in QlikView

left in script

johanlind — Fri, 08 Jul 2011 10:29:31 GMT

I have a filed (Orderdate) like this:

2011-06-14 11:02:59
2011-06-14 11:03:09
2011-06-14 15:14:43
2011-06-14 11:02:50
2011-06-14 14:44:37
2011-06-14 13:51:33

How do I do for just read out the orderdate?

I have tried to use left i the script

date(left(Orderdate,10)) as OrderDate

It will return:

2011-06-14

I just want one post with 2011-06-14 not six posts.

kaushiknsolanki — Fri, 08 Jul 2011 10:33:56 GMT

HI,

Try this way.

Load

Date(OrderDate) as OrderDate

From XYZ

Regards,

Kaushik Solanki

johanlind — Fri, 08 Jul 2011 10:37:28 GMT

I've tried it also but the result is the same.

nagaiank — Fri, 08 Jul 2011 10:39:24 GMT

You may try

Load Distinct SubField(OrderDate,' ',1) as OrderDate1, ...

From ...

kaushiknsolanki — Fri, 08 Jul 2011 10:40:02 GMT

Hi,

From where are you getting this data...?

Try this too.

Date(Date#(OrderDate,'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYYY') as OrderDate

Regards,

Kaushik Solanki

Miguel_Angel_Baeyens — Fri, 08 Jul 2011 10:49:35 GMT

Hello Johan,

Did you try?

Date(Floor(OrderDate)) AS OrderDate

Hope that helps.

BI Consultant

johanlind — Fri, 08 Jul 2011 11:00:28 GMT

Thanks Miguel

Now it works fine.