Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Here is my variable construction:
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