# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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