topic Re: Hide Rows with Suma 0 in Table Simple in QlikView

Hide Rows with Suma 0 in Table Simple

stvn_003 — Wed, 06 May 2015 19:11:59 GMT

Hi buddies, I'm new in QlikView and emerged me a doubt, I have a simple table object in which I have calculated expressions, some of which are sums and other counters, what I want is that the rows are not displayed whose sum is zero .

Note: The 4 last columns of the image are computed expressions.

Re: Hide Rows with Suma 0 in Table Simple

Thu, 07 May 2015 15:16:04 GMT

Hi Steven,

you have the zero coming through as the other expressions are returning values and so lines are populating.

If you put a condition on them to be based on your first column, those rows should drop out.

e.g If([Kilos Totales]<>0,Ultima Ocurrencia expression here)

hope that helps

Joe

Re: Hide Rows with Suma 0 in Table Simple

stigchel — Thu, 07 May 2015 15:20:59 GMT

Try adding a calculated dimension instead of the Código Sap dimension like this:

Aggr(Only({<[Código Sap]={"=Sum(Kilos)>0"}>} [Código Sap]),[Código Sap])

Re: Hide Rows with Suma 0 in Table Simple

buzzy996 — Thu, 07 May 2015 15:35:20 GMT

try tis,write a expression on ur field "Kilos totales",

=sum/count/num({$<Kilos totales<>'0'>}Kilos totales)