Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

philgood34
Contributor II

Dimension limitation with expression

Hi everybody

I have a table with a dimension (SECTORS) and 2 measures ( CIB_CATTC & CATTC_REEL)

i want to select the sectors with CATTC_REEL< CIB_CATTC and be able to display only these sectors

So i tried to use the dimension limitation as shown

limitation.png

don't work :-(

anybody have an idea ?

regards

Phiilippe

3 Replies
karthikoffi27se
Contributor III

Re: Dimension limitation with expression

Hi Philippe,

Please use the below expression  in your measure

=IF(CATTC_REEL< CIB_CATTC ,CATTC_REEL,0)


=IF(CATTC_REEL< CIB_CATTC ,CIB_CATTC ,0)


and in addons please disable the show zero values.


Many Thanks

Karthik

philgood34
Contributor II

Re: Dimension limitation with expression

Hi Karthik ,

great trick !

obviously i added sum( ...) , and it's working !

i thank's you for that

the disadvantage is when i have 10 more measures with aggr expression for example, i have to apply the trick for all ... rather complicated

Anyway ... if there's no alternative with the dimension limitation or other fonctionality , i take your trick !

best regards

Philippe

Re: Dimension limitation with expression

You can do this calculation in the load script if you have many calculations on the script part you can handle it properly and it is optimized way as well.

Community Browser