Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

Or this

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

View solution in original post

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?