topic Re: Simple expression in QlikView

Simple expression

Wed, 25 Nov 2020 16:16:04 GMT

Dear Experts,

My expression is shown below,

IF(REMARKS='SET',0,RANGESUM(LOAN_AMT+INT_DUE-REC_AMOUNT))

Expected results can be achieved with this expression other than grand totals.

Please help me to find the alteration required.

Rgds,

Priyantha.

avinashelite — Fri, 23 Dec 2016 05:32:39 GMT

did not get your requirement could you provide more details ..

Fri, 23 Dec 2016 05:58:28 GMT

as i think i have omitted "SUM" or "AGGR" part from this expression. still i couldn't find which part to where i should insert.

Thanks Avinash for early reply.

Priyantha.

Anil_Babu_Samineni — Fri, 23 Dec 2016 06:06:31 GMT

Share the screen shot where you get the issue and although try this

IF(REMARKS='SET',0,RANGESUM(LOAN_AMT,Interval(INT_DUE-REC_AMOUNT)))

IF(REMARKS='SET',0,RANGESUM(LOAN_AMT,(INT_DUE-REC_AMOUNT)))

Anonymous — Fri, 23 Dec 2016 07:38:54 GMT

Hi Priyantha,

Try this expression:

=SUM({<REMARKS = -{'SET'}>} RangeSum(LOAN_AMT,INT_DUE,-REC_AMOUNT))

Regards!!

sunny_talwar — Fri, 23 Dec 2016 09:07:49 GMT

To more closely mimic the if statement, I would put the negative sign before the equal sign

=Sum({<REMARKS -= {'SET'}>} RangeSum(LOAN_AMT,INT_DUE,-REC_AMOUNT))

or another option is to use Sum(Aggr())

Sum(Aggr(If(REMARKS='SET', 0, RangeSum(LOAN_AMT+INT_DUE-REC_AMOUNT)), ChartDimensionsHere))

Here make sure to replace ChartDimensionsHere with the dimensions from your chart