topic Re: sum(field) not working when using nulls in QlikView

sum(field) not working when using nulls

felcar2013 — Fri, 09 May 2014 15:37:33 GMT

i have two end tables shown in the attached Image. I want to delete the ""Zeros" that appear in the first table. For this i used
the Expression (customer is the fact)

if(len(trim(customer))>0,sum(customer),'')

this solved my Problem, but then i cannot sum the subtotals for "multichannel" Dimension value, as you can see in the second Chart ("# of Club customers")

there are "nulls" in the values of "customer" and i am aggregating by country

How can i get the total there?

thanks

Re: sum(field) not working when using nulls

Jason_Michaelides — Fri, 09 May 2014 15:49:27 GMT

That's because you are replacing numbers with text so you can no longer sum them together. If you really don't want to view them then consider cheating by using conditional colouring to make them white...

Hope this helps,

Jason

Re: sum(field) not working when using nulls

felcar2013 — Mon, 12 May 2014 12:47:11 GMT

thanks

i set a condition for "font" Color and solved the issue

fleipe

Re: sum(field) not working when using nulls

Jason_Michaelides — Mon, 12 May 2014 13:28:03 GMT

Glad it worked. Please mark a correct answer to close the thread.

Jason