Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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?