Skip to main content

New to Qlik Sense

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

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
flames
Contributor III
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

HI_U.JPG

 

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
pradosh_thakur
Master II
Master II

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.
Sue_Macaluso
Community Manager
Community Manager

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