Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
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

Labels (1)
1 Solution

Accepted Solutions
its_anandrjs
Champion III
Champion III

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
Champion III
Champion III

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