Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
AmCh
Creator
Creator

Chart expression in macro QlikView

Hi all,

as I have a chart expression that I use often, I would like to convert it into a macro so that I can easily call it when needed.

The chart expression is as follows:

=(a*$(n)+b*$(m)+c*$(m)*$(q)+d*$(n)*$(q))*Valueloop(1,$(o)) -(a*$(n)+b*$(m)+c*$(m)*$(q)+d*$(n)*$(q))*(Valueloop(1,$(o))-1)

Where m,n,o,q are values entered by the user with the input fields.

where a,b,c,d are imported fields (size=1).

What is the equivalent of this expression in scripting as a function?

Thanks in advance

Labels (4)
1 Reply
morgankejerhag
Partner - Creator III
Partner - Creator III

Maybe you are looking for a master measure?

Morgan Kejerhag
Senior Business Intelligence Consultant
Drake Analytics
http://www.drakeanalytics.se