Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

May be try as - 

Sum(Revenue_$(vPrevious))