topic Re: Expression Calculation in QlikView

Expression Calculation

priyarane — Thu, 26 Feb 2015 13:21:12 GMT

Hi Experts,

Right now I am using expression;

(HNAH_3460S = 'Y' ,sum(if(GBM_SCALED_RWA_HNAH <> 0,GBM_SCALED_RWA_HNAH

,0))/1000000)

As above mentioned one flag I am using(HNAH_3460S='Y') but my requirement is, my expression should work with all Flags if its 'Y' else 0.

Please suggest me if its in other way also like SETanalysis.

My flags are
HBIO_1201S
HBON_10600
HBUS_3607S
HMUS_3285S
HNAH_3460S
HSI_32900
HTCD_37130
HUSI_3401S

Thank you.

Gysbert_Wassenaar — Thu, 26 Feb 2015 13:31:50 GMT

Try something like this:

if(HNAH_3460S = 'Y' AND HBIO_1201S = 'Y' AND ...etc... AND HUSI_3401S = 'Y', sum(GBM_SCALED_RWA_HNAH)/1000000)

priyarane — Thu, 26 Feb 2015 13:38:07 GMT

Not working Gysbert

maxgro — Thu, 26 Feb 2015 13:41:49 GMT

add other flag fields

sum(if( HBIO_1201S & HBON_10600='YY', GBM_SCALED_RWA_HNAH/1000000))

anbu1984 — Thu, 26 Feb 2015 13:43:07 GMT

Can you explain what is not working?

If you want to calculate Sum even if one of the flags are Y, then change AND to OR in Gysbert's solution

buzzy996 — Thu, 26 Feb 2015 13:48:53 GMT

u can also try,

If(HBIO_1201S='Y',sum(if(GBM_SCALED_RWA_HNAH <> 0,GBM_SCALED_RWA_HNAH

,0))/1000000)

If(HBON_10600

='Y',S

sum(if(GBM_SCALED_RWA_HNAH <> 0,GBM_SCALED_RWA_HNAH

,0))/1000000)

If(HBUS_3607S