Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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