Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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!

10 Replies
jackm75
Creator
Creator
Author

I've now included CurveStartMonth as part of the load script, so now it is a data field rather than expression, but I'm still not having any luck.  I'm thinking it's just not doable.  I'll work on getting the data laid out in way to achieve my goal.

Thanks