Espression help...!!

[#1]

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.

[jagan]

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.

[#3]

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