Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sgqliker
Contributor II
Contributor II

Limit a dimension

Hi,

Is there a way to limit my dimension between two exact values?

I want to show responses >10 and <= 20

Thanks

Labels (2)
1 Solution

Accepted Solutions
sunny_talwar

Or this

Aggr(Only({1<Field = {">10<=20"}>} Field), Field)

View solution in original post

6 Replies
Anil_Babu_Samineni

Perhaps this?

If(Field>10 and Field<=20, Field)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

Or this

Aggr(Only({1<Field = {">10<=20"}>} Field), Field)
sgqliker
Contributor II
Contributor II
Author

It doesn't seem to change anything

My measure is a variable with a 'Rank' in it, if this complicates things

sunny_talwar

Which one of the above two did you try? or did you try both?

sgqliker
Contributor II
Contributor II
Author

I have tried both, but neither options work

tresesco
MVP
MVP

Could you share the expression you are trying with?