Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
jackm75
Creator
Creator

Get value of a field dynamically

I have a list of fields called Month01, Month02, Month03, etc... I'm trying to return the value of Month## dynamically by using another field value, CurveStartMonth, to indicate the month numbers. So, if the value of CurveStartMonth is 5, then  'Month' & Num(CurveStartMonth,'00')  returns the desired text in the expression field, Month05, but I need the value of Month05 to be returned.  How can this be done?  Thanks!