Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Re: month- year

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

2 Replies
Not applicable

month- year

Should be this in your script

Mont,

Year,

Month &'-'& Year      as Period

From yout Table;

Re: month- year

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

Community Browser