Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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 II
Partner - Master II

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?