Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
pmenchon
Contributor III
Contributor III

Impossible to make a filtered row invisible

I want to filter a table by a field, but since I have a formula in an expression that uses another filter, the row that is supposed to be filtered still appears.

The row that does not have to appear is the one that has the value "A2" in "CLAVE" field.

The expression that makes it appear is the following (MARGEN):

Sum( TOTAL<Sector,DescripcionSec,DescAgrupacion,TipoProyecto,DescripProyecto> {<TipoRdo={"CC"}, IdBalance={$(=[IdBalance_PG])}, Clave = {"A58"}>} Saldo)/
Sum( TOTAL<Sector,DescripcionSec,DescAgrupacion,TipoProyecto,DescripProyecto> {<TipoRdo={"CC"}, IdBalance={$(=[IdBalance_PG])}, Clave = {"A2"}>} Saldo)

I attach a screen with the problem.

How can I do to invisibilize it?

Thank you all.

2 Replies
BrunPierre
Partner - Master
Partner - Master

The denominator has this modifier <Clave = {"A2"}> that will make the value "A2" appear.

pmenchon
Contributor III
Contributor III
Author

Y no se podría hacer de otra forma para que no apareciese, con un Aggr o con otro tipo de formula?