Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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