topic Re: Create Variable in QlikView

Create Variable

hkg_qlik — Wed, 13 Mar 2013 16:00:45 GMT

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,

Gabriel — Wed, 13 Mar 2013 16:05:05 GMT

Hi,

Could you possibly upload sample data or clarify your requirement.

Regards

Gabriel

Wed, 13 Mar 2013 17:21:32 GMT

Hello!

You can do as below:

vMonthYear = Month&'/'&Year

by Rebeca

Thu, 14 Mar 2013 05:29:33 GMT

Hi,

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

nirav_bhimani — Thu, 14 Mar 2013 06:47:17 GMT

Hi,

Try with vlist,

Where MonthYear is MonthName(date) as MonthYear

vlist= getfieldselections(MonthYear)

Regards,

Nirav Bhimani

Thu, 14 Mar 2013 09:40:19 GMT

Hai,

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

Try This one