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: 
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

Labels (1)
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