topic Re: Espression help...!! in QlikView

Espression help...!!

Tue, 14 Oct 2014 03:25:57 GMT

Dear All

I have attached my table here,

I want to calculate the AGE_ORC for the for the policies which have already calculated the AGE_COM. The calulation result should only be placed against the ME_CODE's

As I'm new to the Qlik View I have tried in many ways to introduce a correct expression.

Regards,

Priyantha.

Re: Espression help...!!

jagan — Tue, 14 Oct 2014 04:58:13 GMT

Hi,

You don't have values for Cat={'AG'} and POSI={'ME'}. If you remove POSI={'ME'} you will get the values.

Use below expression.

=sum({<Cat={'AG'}>} (COM_PRE*AG_COM_ORC+SR*AG_RS_ORC+TC*AG_TC_ORC))/100

Regards,

Jagan.

Re: Espression help...!!

Tue, 14 Oct 2014 10:07:47 GMT

Dear Jagan,

I understood your logic,

Please see the sample table I have posted above carefully,

Then you can see the same REF_NO two times(mostly), so I have calculated the 'BRO_COMM','AGE_COM' and GRO_COM for the same.

Commission structure as shown below.

Ex:- for a particular REF_NO

BA0014D0028271 BRO_COM 15%

BRO_ORC 1% (here ME-7510)

BA0014D0028336 AGE_COM 10%

AGE_ORC 2% (ME-6297)

So now I wanted to calculate the particular BRO_ORC and AGE_ORC against the same REF_NO available against the ME_CODE.(6297and 7510) likewise.

Your opinion in this regard is highly appreciated.

Regards,

Priyantha