topic Re: Average Require...Finding little bit Tricky in QlikView

Average Require...Finding little bit Tricky

pra_kale — Sat, 10 Oct 2015 05:44:26 GMT

Hi All,

I am attaching one sample excel file in that 100 policies are given with their Policy Term and their Product Type.

I just want to know the Average Term for that Product Type..I able to manage to get the answer for (Number of Policies * Term)..but how to find the Average Term segment wise and One summary Table...That I am finding difficult..

1st Requirement is Total 6 Tables are required..

2nd Requirement is Only One Table required which is a summary out-put of this 6 Tables..

In a excel sheet I have put exact calculation and given The Two Requirements..

Please help as I finding little bit Tricky.....

Thanks in Advance..

Re: Average Require...Finding little bit Tricky

MarcoWedel — Sat, 10 Oct 2015 10:09:49 GMT

‌please post sample app to show how far you have come.

thanks

regards

Marco

Re: Average Require...Finding little bit Tricky

pamaxeed — Sat, 10 Oct 2015 10:19:25 GMT

Can you provide row data or a sample app?
I think it is not that complicated what you wanna going to achieve...

Re: Average Require...Finding little bit Tricky

kumarkp412 — Sat, 10 Oct 2015 11:03:48 GMT

you can make the calculation(calculate the Average with the group by Dimension ) in script side and make use the measure, dimension in the chat to get the Average required.

Ex:

In the script side:

Dimension name: Product_type

Load

- - - - -

(Number of Policies * Term) / Total NOP as Avg

- - - - -

Group by Product_type;

In the front side, use the straingt table and add the dimension as product_type and in the measure use the "Avg".

It will show as you required the document.

I hope it helps you.

Thanks

Kumar

Re: Average Require...Finding little bit Tricky

pra_kale — Sat, 10 Oct 2015 12:10:53 GMT

Hi,

Below attached is the application. In that I able to figure out row level Averages but how to take average of a Total that I don't know also working of II second table also little difficult for me.

Thanks in advance for your help.

Re: Average Require...Finding little bit Tricky

pra_kale — Sat, 10 Oct 2015 12:13:00 GMT

Hi,

Below attached is the application...Average of the Total and II requirement I am finding difficult.

Thanks for your help.

Re: Average Require...Finding little bit Tricky

swuehl — Sat, 10 Oct 2015 12:21:05 GMT

Maybe like

=Sum(Aggr(Count(DISTINCT {<Product_Type = {'Ulip'}>} Policy_Number)*Policy_Term,Policy_Term))

/ Count(DISTINCT {<Product_Type = {'Ulip'}>} Policy_Number)

Re: Average Require...Finding little bit Tricky

pra_kale — Sat, 10 Oct 2015 16:44:52 GMT

Hi Swuehl,

Thanks... exactly the way I want.

Re: Average Require...Finding little bit Tricky

MarcoWedel — Sat, 10 Oct 2015 17:05:19 GMT

Please mark the solution as correct that answered your question .

Thanks

Regards

Marco