topic Expression in QlikView

Expression

upaliwije — Wed, 23 Aug 2017 10:52:18 GMT

Dear Friends

I want to write an expression sum({<DIF={'>0'} {'<8'}>}RENEWED_PREMIUM) where I should sum RENEWED_PREMIUM with DIF>0 and DIF<0 . I have written like above but It does not work properly. Pls correct me.

Re: Expression

tresB — Wed, 23 Aug 2017 10:54:23 GMT

Try like:

sum({<DIF={'>0 <8'}>} RENEWED_PREMIUM)

Re: Expression

niclaz79 — Wed, 23 Aug 2017 10:55:10 GMT

Hi, try this:

sum({<DIF={">0<8"}>}RENEWED_PREMIUM)