topic Re: Date format in QlikView

Date format

kunkumnaveen — Tue, 02 May 2017 06:33:10 GMT

Hello,

IN a Date field i have couple of different date formats,how to bring all them in to one format

DATE OF PURCHASE

1)Dec 11 2012 12:00AM

2)2-May-11,19-Jun-08

3)12/30/1999

4)Jul 19 2005 12:00AM

5)NULL

so those are different format i have in my date fields so how to convert in to single format ......

Thanks

Naveen

Re: Date format

Anil_Babu_Samineni — Tue, 02 May 2017 06:41:04 GMT

May be this?

Date(Alt(Date#([DATE OF PURCHASE], 'MMM DD YYYY hh:mmTT'), Date#([DATE OF PURCHASE], 'DD-MMM-YY'), Date#([DATE OF PURCHASE], 'MM/DD/YYYY'), IsNull([DATE OF PURCHASE])), 'DD-MM-YYYY hh:mm:ss TT') as [DATE OF PURCHASE]

More Information

alt ‒ QlikView

Re: Date format

PrashantSangle — Tue, 02 May 2017 06:59:23 GMT

Hello,

As anil suggested alt() work for you,

but It will get difficult if you have date like 1/12/1999,12/1/1999 etc

If you know the date format then it will work good.

Regards,

Re: Date format

kunkumnaveen — Tue, 02 May 2017 07:10:31 GMT

Thanks Anil,it worked...

=count({<Group={'LIFESPACE'} and Group={'CLUB'} and Group={'FINANCE'} and Group={'AD'} >} customerid)

whats wrong with this expression i am trying to display count of customerid who is in all those four group

Re: Date format

Anil_Babu_Samineni — Tue, 02 May 2017 07:12:44 GMT

Don't require and operator, Use this in set analysis. It will consider as AND only

=count({<Group={'LIFESPACE','CLUB','FINANCE','AD'} >} customerid)

Re: Date format

kunkumnaveen — Tue, 02 May 2017 07:20:10 GMT

Anil i am looking for

count of same customer based up on customerid who bought a different product in all the groups

Re: Date format

Anil_Babu_Samineni — Tue, 02 May 2017 07:22:26 GMT

This is the case, you need to create one more thread with Data set and expected result. That would really helps you for further insist

Re: Date format

kunkumnaveen — Tue, 02 May 2017 07:25:44 GMT

Ani the count as to be zero because there is no single customer who bought a product in all the four groups but after using that expression i am getting 32000 as count

Re: Date format

Anil_Babu_Samineni — Tue, 02 May 2017 07:30:13 GMT

In fact, You are not showing any inputs to see. How we know whether how many you have. May be this?

=count({<Group=P(Group) >} customerid)