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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
poisedon
Contributor III
Contributor III

Output from operations between rows

Hi All,

Please see image, I have a data manager with multiples values and I need output with mixed operations between values. How make that? I have to use master items, charts or what? Also if possible I'd like to edit values from input (not in the data manager but in the app) for see how output change. I'm a beginner so please use easy words and steps. Thank you.Untitled.jpg

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Qlik Sense doesn't support Input Fields yet, so you will have to create variables if you want to be able to change values. You can use the Variable extension to create inputs to change the values of the variables.

Once you have the variables for A to G you can more variables that calculate the values like C-B+A or you could create master measures that calculate those values.
Value1: $(C)-$(B)+$(A)
Value2: $(A)^2-$(F)
...etc


talk is cheap, supply exceeds demand