topic Re: Not able to format the Date in QlikView

Not able to format the Date

Wed, 29 Apr 2015 03:48:51 GMT

Hi Team,

I am not able to combine Month and Year field to have it in a format MonthYear(like Mar2014) format only for May Month.

Month format is FY14 Mar and Year format is FY2014,So when I combine New field using formula

Date#(Date#(right(Month,3),'MMM')&right(Year,4),'MMMYYYY') it should give Mar2014 and May2014.But still Month for F14 May is showing as Mar2014,

For your reference I am attaching both the qvw and sample excel .

Re: Not able to format the Date

danieloberbilli — Wed, 29 Apr 2015 04:00:50 GMT

try this

Re: Not able to format the Date

PrashantSangle — Wed, 29 Apr 2015 04:02:35 GMT

Hi,

I am getting desired result.

Please find below screen shot .

Regards,

Re: Not able to format the Date

Wed, 29 Apr 2015 04:17:22 GMT

Hi All,

Just want to know why only for month May it is not working and one time formula i.e Date#(Date#(right(Month,3),'MMM')&right(Year,4),'MMMYYYY') is not working.

Can anyone provide me the solution with qvw as attached.

Thanks for your feedback.

Sreehari

Re: Not able to format the Date

danieloberbilli — Wed, 29 Apr 2015 04:20:24 GMT

I see what you mean - you need an additional Date() format function:

I was also confused why May is still March in my previous example...check this out:

Re: Not able to format the Date

sujeetsingh — Wed, 29 Apr 2015 04:30:02 GMT

It use Date() function for the same

Re: Not able to format the Date

PrashantSangle — Wed, 29 Apr 2015 04:36:46 GMT

Hi,

Well It is screen shot of your report with your expression only.

I did not made any changes to your existing expression. and I am getting expected result as you mention in your post.

Here I am getting May 2014 for FY14 May

Regards

Re: Not able to format the Date

Wed, 29 Apr 2015 04:54:06 GMT

Hi Daniel,

Thanks for your solution,

Sorry I am getting confused which field I have to take as the correct one.

It will be good if you provide the solution as qvw file.

Regards,

Sreehari

Re: Not able to format the Date

danieloberbilli — Wed, 29 Apr 2015 04:57:56 GMT

PFA -

CorrectDate_final is identified by Qlik as a real date field

CorrectDate is not identified as date field but a string value only

Re: Not able to format the Date

Wed, 29 Apr 2015 06:59:55 GMT

Hi ,

I am not getting the correct output which I want.

Still May is mapped to March only.

Thanks Daniel

Re: Not able to format the Date

Wed, 29 Apr 2015 07:02:27 GMT

Hi Max,

Can you please provide the solution in qvw file.

I am not getting output using the same expression.

Thanks in Advance

Sreehari

Re: Not able to format the Date

PrashantSangle — Wed, 29 Apr 2015 07:13:30 GMT

Hi,

Your expression is fine. I did not made any changes to your posted QVW.

It is strange for me that why it is giving you wrong result.

Regards

Re: Not able to format the Date

Wed, 29 Apr 2015 07:18:16 GMT

Hi Max,

FYI ,for me there were no data for 'FY14 Jun' month was only having 'FY14 May' and 'FY14 Mar'.

But unluckly for me the Date# function is not working properly.

Thanks for your support.

Re: Not able to format the Date

anbu1984 — Wed, 29 Apr 2015 07:43:41 GMT

Check this app

Re: Not able to format the Date

Wed, 29 Apr 2015 14:03:14 GMT

Hi Anbu Cheliyan,

Thanks for your reply

Actually this issue is having connection another thread which you only provided the solution(get the count of unique for a month also if it is repeating again in next month or occured before in previous month it s…)

The issue is that when I use Date#(Field,'MMM YYYY') it is not giving the correct output .

I think order by is creating the issue,Can you please help me solving the issue and it will be a great help.

Thanks in Advance

Sreehari

Re: Not able to format the Date

anbu1984 — Thu, 30 Apr 2015 05:15:42 GMT

Check this app