Create Variable

[hkg_qlik]

Hi,

I have two fields that I would like to join and create a variable:

Year field and Month field

Year =  2011, 2012, 2013....

Month = Jan, Feb,Mar.....

Create Variable = vMonthYear: Jan-11, Jan-12......

Thanks,

H

[Gabriel]

Hi,

Could you possibly upload sample data or clarify your requirement.

Regards

Gabriel

[#3]

Hello!

You can do as below:

vMonthYear = Month&'/'&Year

by Rebeca

[#4]

Hi,

Where You filter that month & Year. You have any datefield

[nirav_bhimani]

Hi,

Try with vlist,

Where MonthYear is MonthName(date) as MonthYear

vlist= getfieldselections(MonthYear) 

Regards,

Nirav Bhimani

[#6]

Hai,

month&'-'&right(year,2) as monthyear

Try This one