topic month- year in QlikView

month- year

Tue, 16 Aug 2011 15:07:26 GMT

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

Tue, 16 Aug 2011 15:12:26 GMT

Should be this in your script

Mont,

Year,

Month &'-'& Year as Period

From yout Table;

its_anandrjs — Tue, 16 Aug 2011 15:12:51 GMT

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