Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
jleefjcapital
Creator II
Creator II

embedding a measure (constructed variable) in another measure

Is it possible to reference a measure to construct another measure? 

I created a measure to calculate the % change over time.   Then, I would like to reference this new variable to create another measure needed for the range slider - 

i.e.,

% change measure -  

num(sum(RETAILTRADE_MSA)/below(sum(RETAILTRADE_MSA)) -1,'#.0%')

new measure for range slider -  this is required for the range slider extension that I am using.   It references the min/max values of the variable.   However, I would like to reference the % change measure.  

Sum({$<RETAILTRADE_MSA ={">=$(=vMin_RETAILJOB) <=$(=vMax_RETAILJOB)"}>} RETAILTRADE_MSA)

It is not working well, but not sure if it's the extension that is not working or if it's not working because it is not possible to reference another created measure. 

Thank you,

Jessica

31 Replies
jleefjcapital
Creator II
Creator II
Author

I just approved your request.   Will you be sending me the email address via message?

sunny_talwar

Now you need to either follow me (so that I can message you) or you need to send me a message from my profile