topic Ignore all selections set expression with sum function inside in QlikView

Ignore all selections set expression with sum function inside

Wed, 19 Feb 2014 10:23:52 GMT

Hi,

I'm having an issue. I need to customers which debt balance <>0.00. And this calculation can;t change because after that i will use this calculated expresion in another calculation

I can easily calculate all customers and it is not changing an any selections - this formula is working fine:

=Count({1<CustomerCode=>} CustomerCode)

but if i put a sum expression inside then when i select a customer the result is 1 - it counts the selected customer

This expression is working wrong

=Count({1<CustomerCode={"=Sum(Balance)<>0.00"}>} CustomerCode)

Can you give me a right direction how to achieve it?

thanks

jja

Re: Ignore all selections set expression with sum function inside

Wed, 19 Feb 2014 10:31:11 GMT

Julius,

perhaps write an inner set into the sum:

=Count({1<CustomerCode={"=Sum({1} Balance)<>0.00"}>} CustomerCode)

Fabrice

Re: Ignore all selections set expression with sum function inside

MK_QSL — Wed, 19 Feb 2014 10:31:49 GMT

Try something like below..

=Count({1<CustomerCode={"=Sum({1}Balance)<>0.00"}>} CustomerCode)

Or Like something below...

=COUNT({1}IF(Aggr(SUM({1}Balance),CustomerCode) <> 0, CustomerCode))

Re: Ignore all selections set expression with sum function inside

Wed, 19 Feb 2014 10:37:13 GMT

Hi,

Yes. Seems so little i was missing!!! Thank you!

Re: Ignore all selections set expression with sum function inside

Wed, 19 Feb 2014 10:44:16 GMT

Wellcome

So little, it's true

Fabrice