Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get the value of a variable without using sum

Guys,

Im using the this function to get the length of a player between certain ages (vLengthLow and vLengthHigh(

    Sum({<LENGTH ={">=$(vLengthLow)<=$(vLengthHigh)" }>} LENGTH)

This works but now I only get the sum. And I would like to have just the value. So a little like

   LENGTH

but then with the variables included.

Any thoughts on how i can fix this?

1 Reply
sunny_talwar

May be this:

Sum(DISTINCT {<LENGTH ={">=$(vLengthLow)<=$(vLengthHigh)" }>} LENGTH)


or


Only({<LENGTH ={">=$(vLengthLow)<=$(vLengthHigh)" }>} LENGTH)