topic Re: Logic Help in opportunity caliculaton? in QlikView

Re: Logic Help in opportunity caliculaton?

ganeshreddy — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

PFA QVW, I have two sheets in the attached QVW, Sheet1 report is giving the correct results and I am unable to get the totals of Sheet1 report to the sheet2 report . At the moment the sheet2 report has the incorrect results for Total GWP of opportunity and current participation. Please help me to get the desired output I am struggling since last few days to get the results, please suggest me any new expressions or steps to make the logic in the script. Help will be much appreciated.

The expected output should be like below.

But current output is like below

Thanks,

Ganesh

Re: Logic Help in opportunity caliculaton?

ganeshreddy — Wed, 15 Nov 2017 10:44:31 GMT

Hi tresesco‌,

Is there any work around that I can do to achieve the desired results as I showed in the previous replay, Please suggest.

Thanks,

Ganesh

Re: Logic Help in opportunity caliculaton?

Anil_Babu_Samineni — Wed, 15 Nov 2017 13:28:13 GMT

For Total GWP, Try this?

Sum({<TransType={'T'}>} TOTAL GrossWrittenPremium_GBP)

Total GWP of Opportunity - Can you explain the logic?

Re: Logic Help in opportunity caliculaton?

ieuyar — Wed, 15 Nov 2017 15:01:59 GMT

Try below expression on Total GWP:

$(=Sum({<TransType={'T'}, MarketName=>}GrossWrittenPremium_GBP))