topic Re: Error in expression in QlikView

Error in expression

upaliwije — Tue, 21 Apr 2015 07:00:24 GMT

Hi friends

sum( {$<YEAR = {"$(=Only([YEAR]))"},CC_CODE<>{"00000"}>} [PREMIUM] )

The expression is not working. Pls help me to correct it

Thanks

fvelascog72 — Tue, 21 Apr 2015 07:04:48 GMT

Try:

sum( {$<YEAR = {"$(=Only([YEAR]))"},CC_CODE={{*}-{"00000"}>} [PREMIUM])

sushil353 — Tue, 21 Apr 2015 07:05:14 GMT

Hi,

Try below expression:

sum( {$<YEAR = {"$(=Only([YEAR]))"},CC_CODE-= {"00000"}>} [PREMIUM] )

HTH

sushil

Marcellino_Groothof — Tue, 21 Apr 2015 07:10:17 GMT

Hi,

Try this,

sum( {$<YEAR = {$(=Only([YEAR]))},CC_CODE-={"00000"}>} [PREMIUM] )

Regards,

Marcellino

ashfaq_haseeb — Tue, 21 Apr 2015 07:10:20 GMT

Hi,

Check this

sum( {$<YEAR = {"$(=Only([YEAR]))"},CC_CODE-={"00000"}>} [PREMIUM])

Regards

ASHFAQ

upaliwije — Tue, 21 Apr 2015 07:49:51 GMT

Thanks all