Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
skychris
Contributor II
Contributor II

Variable to be the input for headers

Hi All QS Guru,

I got various hardcoded column   Revenue_Jul22,  Revenue_Aug22,  Revenue_Sep2 etc

try using QS bundle variable input and bring to the measure

'Revenue_' & $(vPrevious)   =>. Displaying it is ok

but when apply with Sum('Revenue_' & $(vPrevious)). it returns me 0

what is the correct syntax for variable embed to field name ?

thank you

 

 

 

 

Labels (1)
1 Reply
Digvijay_Singh

May be try as - 

Sum(Revenue_$(vPrevious))