topic Re: Set Analysis in QlikView

Set Analysis

krishna20 — Sun, 29 Jun 2014 10:39:38 GMT

Hi friends,

i need to get Earned Premium of year wise.my requirement is

IF(TP_POL_TO_DT>vCurrentYear)=(sum((TP_PREM_LC_1-TP_DISC_LC_1)+(TP_LOAD_LC_1)-(TP_BRK_COMM_LC_1-TP_INW_COMM_LC_1))/(TP_POL_TO_DT-TP_POL_FM_DT))*(vCurrentYear-TP_POL_FM_DT))

else

Earned Premium=Premium.

Please convert the above expression to set analysis.

Please check my expression is there any wrong in this applying set analysis because i'm not getting any data.

=sum({$<year={"TP_POL_TO_DT>vCurrentYear"}>}(sum((TP_PREM_LC_1-TP_DISC_LC_1)+(TP_LOAD_LC_1)-(TP_BRK_COMM_LC_1-TP_INW_COMM_LC_1)) /(TP_POL_TO_DT-TP_POL_FM_DT))*(vCurrentYear-TP_POL_FM_DT))

=if((TP_POL_TO_DT>vCurrentYear),(sum((TP_PREM_LC_1-TP_DISC_LC_1)+(TP_LOAD_LC_1)-(TP_BRK_COMM_LC_1-TP_INW_COMM_LC_1)) /(TP_POL_TO_DT-TP_POL_FM_DT))*(vCurrentYear-TP_POL_FM_DT))

Regards

Krishna

Re: Set Analysis

Gysbert_Wassenaar — Mon, 30 Jun 2014 08:00:34 GMT

Try:

sum({$<year={"TP_POL_TO_DT>$(vCurrentYear)"}>}((TP_PREM_LC_1-TP_DISC_LC_1)+(TP_LOAD_LC_1)-(TP_BRK_COMM_LC_1-TP_INW_COMM_LC_1))/(TP_POL_TO_DT-TP_POL_FM_DT))*(vCurrentYear-TP_POL_FM_DT)

Re: Set Analysis

krishna20 — Mon, 30 Jun 2014 08:21:19 GMT

Dear Gysbert,

Thank you for your reply.If i want to give else condition in set analysis,how can i mention?

i have calculated like this.

=if(TP_POL_TO_DT>vCurrentYear,(sum((TP_PREM_LC_1-TP_DISC_LC_1)+(TP_LOAD_LC_1-TP_BRK_COMM_LC_1-TP_INW_COMM_LC_1)))/
(TP_POL_TO_DT-TP_POL_FM_DT)*(vCurrentYear-TP_POL_FM_DT),Sum((TP_PREM_LC_1-TP_DISC_LC_1)+TP_LOAD_LC_1))

Regards

krishna

Re: Set Analysis

Gysbert_Wassenaar — Mon, 30 Jun 2014 08:24:12 GMT

You cannot do branching logic in set analysis. An else condition is not possible. If you need that then you need to use and if-else statement.

Re: Set Analysis

krishna20 — Mon, 30 Jun 2014 08:27:28 GMT

Is my above expression is correct?branching of expressions.

Re: Set Analysis

Gysbert_Wassenaar — Mon, 30 Jun 2014 08:41:30 GMT

The branching looks ok.

Re: Set Analysis

krishna20 — Mon, 30 Jun 2014 08:45:06 GMT

Thank You..How can we assign '%' to the particular row?

Regards

Krishna