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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
drohm002
Creator II
Creator II

Creating a variable

Hello, I am trying to create a variable the sums the field [Turn Around Time].  See the picture below, when i create the variable called TurnAroundTime as sum([Turn Around Time]) i get the total for everything on each line, as opposed to the individual total.  Does anyone know how to get the individual total whenever i am trying to use a variable for this?  I want to make a variable, i know there are other ways to accomplish this as evidenced by my 2nd column there, but i want to make this work with a variable.  Thank you! I also showed how i constructed my variable below.

drohm002_0-1718546744952.png

Here is my variable construction:

drohm002_1-1718546812206.png

 

 

1 Reply
Or
MVP
MVP

This is really well covered in an existing post, so I'll link that rather than trying to explain it:

https://community.qlik.com/t5/Design/The-Magic-of-Variables/ba-p/1465499