Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

month- year

hi all,

i have month and year in my data separetly. but i want to combined it....

eg : my output will be jan-2010 lik that

thanks in advance

regards

1 Solution

Accepted Solutions
its_anandrjs

Hi Usha,

You need to use Monthname(Datefield) as MonthYear and make new field, also you try Month(Datefield)&'-'&Year(Datefield) as MonthYear

Regards,

Anand

View solution in original post

2 Replies
Not applicable
Author

Should be this in your script

Mont,

Year,

Month &'-'& Year      as Period

From yout Table;

its_anandrjs

Hi Usha,

You need to use Monthname(Datefield) as MonthYear and make new field, also you try Month(Datefield)&'-'&Year(Datefield) as MonthYear

Regards,

Anand