Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

sum(field) not working when using nulls

hi

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

1 Solution

Accepted Solutions
Partner
Partner

Re: sum(field) not working when using nulls

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

View solution in original post

3 Replies
Partner
Partner

Re: sum(field) not working when using nulls

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

View solution in original post

Partner
Partner

Re: sum(field) not working when using nulls

thanks

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

fleipe

Partner
Partner

Re: sum(field) not working when using nulls

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

Jason