topic Converting a variable name to Month number in QlikView

Converting a variable name to Month number

zagzebski — Sat, 25 Jul 2015 17:00:28 GMT

I have a variable (vMonthNum) that I access through an input box. I have a constraint on it to show listed values referencing a Month field (Jan, Feb, Mar, etc)

I want to convert the selection the user makes (Jan, Feb, Mar, etc) to a number that corresponds to the month. So if from the drop down the user selects Mar I need it converted to 3. Looking for the expression to do this.

Thanks in advance,

Steve

Re: Converting a variable name to Month number

sunny_talwar — Sat, 25 Jul 2015 17:03:12 GMT

Try this:

vVar2 = Num(Date#(vVar1, 'MMM'))

vVar2 = Num(Month(Date#(vVar1, 'MMM')))

where vVar1 is linked to your inputbox

HTH

Best,

Sunny

Re: Converting a variable name to Month number

sunny_talwar — Sat, 25 Jul 2015 17:07:24 GMT

Attaching a sample:

Re: Converting a variable name to Month number

zagzebski — Sat, 25 Jul 2015 17:24:11 GMT

Thank so much!

Re: Converting a variable name to Month number

sunny_talwar — Sat, 25 Jul 2015 17:24:55 GMT

No problem

I am glad I was able to help.

Best,

Sunny