Month

[qlikview979]

Hi Experts,

I have in  date in Excel like

STARTDATE  ENDDATE

27/03/2016      31/05/2016

I need output like

[qlikview979]

Hi Digvijay,

Exactly  Output. .thanks for your support.

Here 'Chr(13) 'what will represent and if i add the july month  in End date  i am getting like this

"April,May,June"  Why march Month is not coming.

Regards,

Mahesh

[Anil_Babu_Samineni]

Mahesh,

There is no Use of that Chr()

Expression :

=Date(Date#(StartDate,'DD/MM/YYYY'),'YYYY_MMM') &

Date(Addmonths(Date#(StartDate,'DD/MM/YYYY'),1),'YYYY_MMM') &

Date(Date#(EndDate,'DD/MM/YYYY'),'YYYY_MMM')

Note: Close this Thread ASAP if Correct??

[qlikview979]

Hi,

Here one more Doubt I am loading data from" Excel this code is not working".

Regards,

Mahesh

[qlikview979]

Hi Anil,

I am loading data from excel file "Digvijay Singh" Code is not working.

[Anil_Babu_Samineni]

Why, It should work.

QlikView is Case Sensitive. Please try to edit the field names....

[Anil_Babu_Samineni]

Working

Check this

[Digvijay_Singh]

Hi Mahesh,

The data I added manually, you can load it from Excel, but what I did will work for the data you shared, let me think of making it dynamic. I just shared to get more details 

[qlikview979]

Hi Anil,

Please check once if i add the June  month in excel .i am not getting "March,April,May, June" This 4 months.

I am getting only Three months ? why one month is missing ?

[qlikview979]

Hi Digvijay,

Please find the attached file.

Sorry now your code is working, But here i Have one doubt If i  change in my source "May

Instead of "june " i am getting only Three months .

Here I want Mar,Apr,May,June. if i add more one more month also I want that month name also.

Regards,

Mahesh.

[qlikview979]

Hi Manuel Capella,

When i go for reload  I'm got getting any thing data.

Regards,

Mahesh,