topic Re: Expression in QlikView

Expression

upaliwije — Tue, 18 Feb 2014 06:48:50 GMT

sum( {$<To_YEAR=,[To_MONTH]{'<$(=Max([R_MONTH]))'}>} [PREMIUM] )

I have written the above expression and it is not working. Pls check my attached document see what is wrong.

What I want to calculate is sum of Premium for the selected period and importantly To_month<R_Months

Re: Expression

albertovarela — Tue, 18 Feb 2014 06:53:38 GMT

You were missing an equal sign after the To_MONTH

sum( {$

To_YEAR =

,To_MONTH = {'<$(=Max([R_MONTH]))'}

} [PREMIUM] )

Re: Expression

upaliwije — Tue, 18 Feb 2014 07:04:43 GMT

Thanks for your reply

But still it is not working. Can U pls check with my document reply to me with attachment

Thanks

Re: Expression

er_mohit — Tue, 18 Feb 2014 07:05:04 GMT

Try this

sum(if(num(To_MONTH)<num(R_MONTH),PREMIUM))

sum( {<[To_MONTH]={'<$(=Max([R_MONTH]))'},To_YEAR>} [PREMIUM] )

Re: Expression

Peter_Cammaert — Tue, 18 Feb 2014 07:37:32 GMT

If you want to sum() all values for To_MONTHs lower than R_MONTH, then why put To_MONTH as a dimension in your chart? Remove the dimension, correct the expression as suggested before and it will work.

Peter