topic Re: sum free from missing values in QlikView

sum free from missing values

Wed, 10 Apr 2013 04:41:12 GMT

AOA all

I want to get sum of amount free from missing or null values...

details:

I have a table with dimension of (stock_id,Partno,item) expression is =sum(bal_qty) as "Qty in stock"

Total shows in a table is 107556.

but when I go on table property and check supress null values in dimension tab for each dimension.

qty reduce to 98337 which is correct

now i want to show this 98337 value in text box.

kinldy adivce how to get purified value in text box because when i give =sum(bal_qty) in text box its shows 107556.

thnks

Thu, 11 Apr 2013 15:56:28 GMT

no one to solve this??????

MarcoARaymundo — Thu, 11 Apr 2013 16:44:52 GMT

try this

sum({<stock_id={'0','$(=isnull(stock_id)=0)'}>} bal_qty)

Thu, 11 Apr 2013 17:11:48 GMT

Hi,

I Didnt get your point can you upload your sample application. Hope it is helpful to solve this.

MarcoARaymundo — Thu, 11 Apr 2013 19:28:25 GMT

Done!

calvindk — Fri, 19 Apr 2013 08:08:39 GMT

Here you go:

Sum({<stock_id = P(stock_id) >} bal_qty)

ryanhicks — Wed, 01 May 2013 18:49:56 GMT

Anders solution works for me.

v_iyyappan — Wed, 01 May 2013 19:46:17 GMT

Hi,

Use the expression like this in textbox

=Sum({<stock_id-= ('-') >} bal_qty)

Regards,

Iyyappan