topic Re: Date format issue in QlikView

Date format issue

udaya_kumar — Mon, 16 Jun 2014 11:03:36 GMT

Hi,

I have a date field called "Month_Name".

I have values in that field like

2011

2012

2013

1/5/2014

2/4/2014

When i load this field into qlikview, i am getting values like

7/3/1905

7/4/1905

7/5/1905

1/5/2014

2/4/2014

So the years like 2011, 2012, 2013 values are converted to some date format.

But i dont want that format. I want the values to be like 2011,2012,2013,1/5/2014,2/4/2014.

How can we achieve this?

Can someone help me please?

Thanks in advance

Re: Date format issue

Mon, 16 Jun 2014 11:05:32 GMT

Why do you have years in Month_Name?

Could u provide sample file=?

Re: Date format issue

ashwanin — Mon, 16 Jun 2014 11:06:15 GMT

Can you provide the sample file, from where you are loading the dates in QV?

Re: Date format issue

ashfaq_haseeb — Mon, 16 Jun 2014 11:07:00 GMT

Hi, try like below.

if (len(Month_Name)=4,num(Month_Name),(Month_Name)) as Date

Regards

ASHFAQ

Re: Date format issue

udaya_kumar — Mon, 16 Jun 2014 11:07:36 GMT

Hi Thomas,

Thanks for the reply.

The requirement was like that, they want to see year and month together as a dimension in a chart.

So we added year and month together in a single field.

Re: Date format issue

udaya_kumar — Mon, 16 Jun 2014 11:08:50 GMT

Hi Ashfaq,

I tried that same expression before.

But problem is, it is loading the year like that in front end.

So the len(Month_Name)=4 condition is not working.

Re: Date format issue

MK_QSL — Mon, 16 Jun 2014 11:09:45 GMT

Try something like below

Load

ALT(Date(Date#(Date,'YYYY'),'YYYY'),

Date(Date#(Date,'M/D/YYYY'))) as Date

Inline

[

Date

2011

2012

2013

1/5/2014

2/4/2014

];

Re: Date format issue

ashfaq_haseeb — Mon, 16 Jun 2014 11:11:00 GMT

Hi, can you attach your qvw.

Regards

ASHFAQ