# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Community Browser