topic Re: Expression in Set analysis in QlikView

Expression in Set analysis

Thu, 06 Aug 2015 09:45:12 GMT

Hi Community,

How to write the below expression in Set

If CR RWA <> 'GMR or OPR' then SUM (RWA)

Thank you

Re: Expression in Set analysis

Kushal_Chawda — Thu, 06 Aug 2015 09:48:55 GMT

try

=sum({<[CR RWA]-={'GMR','OPR'}>}RWA)

Re: Expression in Set analysis

Gysbert_Wassenaar — Thu, 06 Aug 2015 09:49:13 GMT

You can't. Set analysis does not support branching. But if you mean sum(if([CR RWA] <> 'GMR or OPR', RWA) then you can use sum({<[CR RWA]-={'GMR or OPR'}>}RWA)

Re: Expression in Set analysis

Thu, 06 Aug 2015 09:53:40 GMT

Hi Gysbert,

Its - If CR RWA <> 'GMR' or 'OPR' then SUM (RWA)

Re: Expression in Set analysis

Thu, 06 Aug 2015 09:56:27 GMT

So In such case, we have to use straight IF condition like

if([CR RWA] <> 'GMR' or 'OPR'(sum(rwa))

Am I right Gysbert?

Re: Expression in Set analysis

Thu, 06 Aug 2015 09:58:18 GMT

Hi Kush,

It's act like AND. I mean to say it will remove both(GMR and OPR) from sum.

Re: Expression in Set analysis

Gysbert_Wassenaar — Thu, 06 Aug 2015 09:59:58 GMT

If you're testing for two values 'GMR' and 'OPR' and not one value 'GMR or OPR' then try if([CR RWA] <> 'GMR' or [CR RWA] <> 'OPR',sum(RWA))