topic Date Format in QlikView

Date Format

NavinReddy — Tue, 23 Jul 2013 10:56:50 GMT

Hi Community

i have date format like the way(02/11/2013)

But how can i set This date like as(Feb 11,2013)

Thanks

Rohith

Re: Date Format

kaushiknsolanki — Tue, 23 Jul 2013 10:58:59 GMT

Hi,

Try this,

Date(Date,'MMM DD,YYYY')

Regards,

Kaushik Solanki

Re: Date Format

NavinReddy — Tue, 23 Jul 2013 11:04:45 GMT

Hi kaushik,

im using this function, date(Max(Week-7,'Month/DD/YYYY'))

its not working for me

Thanks,

rohith

Re: Date Format

kaushiknsolanki — Tue, 23 Jul 2013 11:07:13 GMT

Hi,

Try this

Date(Max(Week)-7,'MMM/DD/YYYY')

Regards,

Kaushik Solanki

Re: Date Format

NavinReddy — Tue, 23 Jul 2013 11:10:49 GMT

Thanks you its working fine

Re: Date Format

NavinReddy — Tue, 23 Jul 2013 11:43:12 GMT

Hi,

help me its not working

="Total Calls in Previous Week" ( '&date(Max(Week)-7,'MMM DD,YYYY') -''&date(Max(Week)-7,'MMM DD,YYYY')

Re: Date Format

kaushiknsolanki — Tue, 23 Jul 2013 11:44:47 GMT

Try this.

='Total Calls in Previous Week ( '&date(Max(Week)-7,'MMM DD,YYYY')&'-'& date(Max(Week)-7,'MMM DD,YYYY')

Regards,

Kaushik Solanki

Re: Date Format

NavinReddy — Tue, 23 Jul 2013 11:50:52 GMT

Thank you its woking

Re: Date Format

NavinReddy — Tue, 23 Jul 2013 12:26:21 GMT

Hi Kaushik,

sum({$<Week = {'>=03/24/13 <=03/30/13'}>}[Client Calls]),

sum({<Week = {">=$(=date(Max(Week)-7))<=$(=date(Max(Week)))"},Week=>} [Client Calls])

These two expressions giving differ ent results

second expression im selecting same month only

again different results,

plz help me

thanks,

rohith