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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Emil_bros
Contributor III
Contributor III

variable in set analysis for dynamic change

Hi,

I need to find a formula where variable 'VERSION' changes dynamically in relation to given month.

In my case names of VERSIONS are corresponding to MONTH names (formated as data)

 
 

 

 

 

 

 

 

My formula is not working:

sum({<VERSION = {'=Month'}>} VAL)

As a result I want the formula to take value for EACH MONTH from different VERSION

10 Replies
Emil_bros
Contributor III
Contributor III
Author

Hi Sunny,

now I need to implement this solution to another report. Despite using same logic I can't get correct result.

I have desctibed issue inder this link. Can you kindly take a look?

https://community.qlik.com/t5/QlikView-Creating-Analytics/dynamic-variable-in-expression/m-p/1655524...

 

Emil