topic Re: Sum if - what's wrong with my expression? in QlikView

Sum if - what's wrong with my expression?

Wed, 01 Jun 2016 13:38:42 GMT

Hello

I was wondering what's wrong with my expression?

sum(if([Tariff range]='No tariff',({<[Application Status]={'C/F','U/F'}>} [FTE dashboard])))

There is an error and I am pretty sure it's something to do with the [Application Status]....'U/F bit,, as it is work fine without this part i.e. sum(if([Tariff range]='No tariff',[Stprog Count FTE])).

Any ideas?

Thanks

Ewa

Re: Sum if - what's wrong with my expression?

andrespa — Wed, 01 Jun 2016 15:46:22 GMT

Hi Ewa, try:

if([Tariff range]='No tariff', sum({<[Application Status]={'C/F','U/F'}>} [FTE dashboard]))

Re: Sum if - what's wrong with my expression?

swuehl — Wed, 01 Jun 2016 15:48:36 GMT

Try

sum({<[Application Status]={'C/F','U/F'}>} if([Tariff range]='No tariff',[FTE dashboard]))

sum({<[Application Status]={'C/F','U/F'}, [Tariff range] = {'No tariff'}>}[FTE dashboard])

Re: Sum if - what's wrong with my expression?

Aurelien_Martinez — Wed, 01 Jun 2016 15:49:10 GMT

Hi Ewa,

sum({<[Application Status]={'C/F','U/F'}, [Tariff range]={'No tariff'}>} [FTE dashboard])

Aurélien

Re: Sum if - what's wrong with my expression?

luis2793 — Wed, 01 Jun 2016 15:54:42 GMT

Hello Ewa.

Please try with this expression:

if([Tariff range]='No tariff',sum({<[Application Status]={'C/F','U/F'}>} [FTE dashboard]))

Re: Sum if - what's wrong with my expression?

Thu, 02 Jun 2016 12:45:39 GMT

Thanks Andres, unfortunately this suggestion did not work for me.

Re: Sum if - what's wrong with my expression?

Thu, 02 Jun 2016 12:46:15 GMT

Swuehl

Thanks very much, the first suggestion solved the problem, brilliant!

Re: Sum if - what's wrong with my expression?

oknotsen — Thu, 02 Jun 2016 13:00:34 GMT

If your question is now answered, please flag the Correct Answer.

If not, please make clear with which part of this topic you still like to get help .