# New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
Highlighted
New Contributor III

## Restrict display of values

Hello,

as shown in the pic, i am trying to limit the dimension based on a measure.

the one you are seieng is  - limited to display >0.6

But, what i wanted is to limit >0.6 and <1

I have a complex formulae foe measure.

my dimesion name is : FIRSTPROD

measure calculation :

=sum(aggr(sqr(sum(TOTAL <PNUM, ECUST> {<\$>*<QTR={">=\$(=\$(vAgo))"},\$(vMRSet)>}\$(vMQld))
/
sum(TOTAL <PNUM> {<\$>*<QTR={">=\$(=\$(vAgo))"},\$(vMRSet)>}\$(vMQld))), PNUM, ECUST))

Help me how to keep two bounds in limits, Thanks.

2 Replies
Honored Contributor II

## Re: Restrict display of values

There are so many variable in your expression

to restrict FIRSTPROD you need to write

`FIRSTPROD={"=>0.6 <1"}`

Add this in your expression inside the set expression. May be like this

```=sum(aggr(sqr(sum(TOTAL <PNUM, ECUST> {<\$>*<QTR={">=\$(=\$(vAgo))"},\$(vMRSet), FIRSTPROD= {">0.6 <1}>}\$(vMQld))
/
sum(TOTAL <PNUM> {<\$>*<QTR={">=\$(=\$(vAgo))"},\$(vMRSet),FIRSTPROD= {">0.6 <1}>}\$(vMQld))), PNUM, ECUST))```
Learning never stops.
Community Manager

## Re: Restrict display of values

Is this about QlikView or Qlik Sense? I would like to move it to the correct product forum.
Sue Macaluso