Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chapil
Contributor III
Contributor III

Limitation option in an object table

hello guys, 

I discovered few days ago the option "limitation" in the pivot table. 

I wanted to print only lines for which my measure is equal to 1. 

This is my formula measure : wildmatch( aggr( NODISTINCT sum(AMOUNT),[com]) =0,0). It gave my 1 if the sum<>0. 

The limitation option doesn't work, and I don't know why ? do you think this can du to the number format ? 

 

Thanks a lot 

 

Behind a screen of the limitation option I used 

chapil_0-1650382022626.png

 

 

Labels (2)
5 Replies
vinieme12
Champion III
Champion III

this option is to limit the number of rows, it does not check the values in the field

if you want to limit dimension based on a measure try below 

Calculated Dimension

=if( aggr( NODISTINCT sum(AMOUNT),[com]) >0,YourDimension,null()) << Uncheck show null values on this column

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

Or you can just Add Dimensions

Com

Entity_cc_company

Measure = Sum(Amount)

 

Then Under Data Handling >> Uncheck Include 0 values

this will hide all rows where (Sum(Amount)=0)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
chapil
Contributor III
Contributor III
Author

Hello vinieme12, 

 

Thanks a lot for your answer

Yes it works but I would like to avoid if expression. 

chapil
Contributor III
Contributor III
Author

Thanks for this second solution 

Good idea, but I've got other measure in my table so it doesn't work. 

 

vinieme12
Champion III
Champion III

then Option1

either use a  calculated dimension as shown above

or Option2:

change your measure 

Measure =  if(Sum(Amount)>0,Sum(Amount))  and then Under Data Handling >> Uncheck Include 0 values

NOTE: you will have to check if(Sum(Amount)>0, OtherMEasure)   for all other measures in that chart

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.