Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

New to Qlik Sense

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

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Alejandro3
Contributor
Contributor
‎2022-05-04 11:16 AM

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)
Labels
64 Views
0 Likes
1 Reply
vinieme12
Champion III
Champion III
‎2022-05-04 02:15 PM

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.
42 Views
0 Likes