# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for
Did you mean:
Contributor III

## As delete records with values of expressions = 0 in pivot table ??

Hi All,

I have a pivot table with 3 expressions like this:

Expr1

+ sum({<FechaPago = {"<=\$(=vFecSaldoInicial)"}, FechaAnulaPago = {"0"} + {">\$(=vFecSaldoInicial)"}>} TotalPago)

+ sum({<FechaAjuste = {"<=\$(=vFecSaldoInicial)"},FechaAnulaAjuste = {"0"} + {">\$(=vFecSaldoInicial)"}>}TotalAjuste)

Expr2

Expr3

+ sum({<FechaPago = {"<=\$(=vFecSaldoFinal)"}, FechaAnulaPago = {"0"} + {">\$(=vFecSaldoFinal)"}>} TotalPago)

//+ sum({<FechaPagoCont = {"<=\$(=vFecSaldoFinal)"}, FechaAnulaPagoCont = {"0"} + {">\$(=vFecSaldoFinal)"}>} TotalPagoCont)

+ sum({<FechaAjuste = {"<=\$(=vFecSaldoFinal)"},FechaAnulaAjuste = {"0"} + {">\$(=vFecSaldoFinal)"}>}TotalAjuste)

as the pivot table to delete records whose three expressions are 0 ??

Henry C.

1 Solution

Accepted Solutions

Then you need to add an if statement to all the other expressions that makes the expression return 0 if those other three expressions all return 0.

talk is cheap, supply exceeds demand
3 Replies

If the results are really exactly 0 instead almost 0 then those rows would be suppressed automatically by default. My guess is therefore that one of the expressions returns results that are not exactly 0. Can you post a small qlikview document that demonstrates the problem?

talk is cheap, supply exceeds demand
Contributor III
Author