topic Re: Date Format in QlikView

Date Format

krishna20 — Sun, 17 Aug 2014 07:53:15 GMT

Hi Friends,

I'm having a problem in Retrieving the date format.

I'm having the field Ret_Month and need to use it as dimension.

My Ret_Month is in 01,02,03,04......

I need show like it as full names January....December.

I used like below.

=if(date(Ret_Month,'MMMM'),Ret_Month)

But, i'm getting as January, December, January, January,January......January.

Please anyone suggest me what may be the problem is...

Thanks & Regards

Krishna

Re: Date Format

ecolomer — Sun, 17 Aug 2014 08:04:06 GMT

You need to see the SET sentence in the begining script .... and see the QV file attached

Re: Date Format

MK_QSL — Sun, 17 Aug 2014 08:05:34 GMT

Load

Date(Date#(SubField('$(MonthNames)',';',Ret_Month),'MMM'),'MMMM') as Ret_MonthFull

Inline

[

Ret_Month

];

Re: Date Format

ashfaq_haseeb — Sun, 17 Aug 2014 08:07:05 GMT

Hi,

Can you post a sample qvw file.

Regards

ASHFAQ

Re: Date Format

ecolomer — Sun, 17 Aug 2014 08:37:22 GMT

Attaced a Qv file

Re: Date Format

krishna20 — Sun, 17 Aug 2014 09:19:22 GMT

Hi Colomer,

i used the expression which you suggested me.but its not working.

regards

Krishna

Re: Date Format

ashfaq_haseeb — Sun, 17 Aug 2014 09:20:43 GMT

Post your sample file.

Regards

ASHFAQ

Re: Date Format

ecolomer — Sun, 17 Aug 2014 09:21:12 GMT

Get me the QV file to see

In my QV they are another file xls in charge script

Here you have all

Re: Date Format

MarcoWedel — Sun, 17 Aug 2014 09:34:35 GMT

Maybe also:

Date#(SubField('$(LongMonthNames)',';',Ret_Month),'MMMM')

Regards

Marco

Re: Date Format

krishna20 — Sun, 17 Aug 2014 09:35:22 GMT

Hi Colomer,

Please find the below attachment and guide me further.

Regards

Krishna

Re: Date Format

SunilChauhan — Sun, 17 Aug 2014 09:37:49 GMT

simply suggets to use

Load * inline [

Ret_Month ,fullmonth,

01,Janauray

02,February

03,March

04,April

05,May

06,Jun

07,July

08,August

09,September

10,November

11,December

];

use fullmonth in place of RetMonth in Charts

Re: Re: Date Format

ecolomer — Sun, 17 Aug 2014 09:42:38 GMT

here you are

Re: Re: Date Format

ashfaq_haseeb — Sun, 17 Aug 2014 09:45:42 GMT

Have a look at attached application.

Edit:

You can even use the below code too.

Date(Date#(MONTH,'MM'),'MMMM') as TestField,

Regards

ASHFAQ

Re: Date Format

MarcoWedel — Sun, 17 Aug 2014 11:51:28 GMT

Hi Krishna,

as far as I can see, Manish Kachhia was the first who came up with the

Date(Date#(SubField('$(MonthNames)',';',Ret_Month),'MMM'),'MMMM') as Ret_MonthFull

solution.

regards

Marco

Re: Date Format

krishna20 — Sun, 17 Aug 2014 11:55:06 GMT

Thank You,

Manish

Re: Date Format

MK_QSL — Sun, 17 Aug 2014 12:19:24 GMT

Thanks Marco for pointing this out...

Community Members satisfaction is more important for me rather than Earning Point.

As far as this question closed... I am happy...