Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Alejandro3
Contributor
Contributor

Filtrar valores Mayores a cierto valor

Alejandro3_0-1651677236920.png

Quiero realizar un filtro que solo me muestre los valores superiores de 10 millones del campo Sumatoria Total

Alejandro3_1-1651677327687.png

Lo he intentado por este lado pero no me deja.

Labels (3)
1 Reply
vinieme12
Champion III
Champion III

that is used to show/hide the entire column, to restrict values in chart you can restrict your dimension as below

 

replace AfiliadoID with calculated dimension like below

 

=aggr(   if( ExpressionFor Suma Totaria, AfiliadoID) > pow(10,6) , AfiliadoID, null() ) , AfiliadoID )

<< then Uncheck Show Null Values for this calculated dimension

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