topic Re: Percentage of Total Set Analysis in QlikView

Percentage of Total Set Analysis

Thu, 26 Mar 2015 12:41:25 GMT

Hi All,

I need to work out the percentage using set analysis, but my understanding of set analysis isn't great.

Simplified example:

I have used set analysis to count the total enquiries sent to InsurerA; this gives me the following outcome:

Expression behind No of Enquiries Sent:

=Sum({$<Insurer = {InsurerA}>}1)

Can anyone suggest an expression for the percentage column?

Thank you

MK_QSL — Thu, 26 Mar 2015 12:46:12 GMT

=Sum({$<Insurer = {InsurerA}>}1)/Sum(TOTAL {$<Insurer = {InsurerA}>}1)

=Sum({$<Insurer = {InsurerA}>}1)/Sum(ALL {$<Insurer = {InsurerA}>}1)

PrashantSangle — Thu, 26 Mar 2015 12:47:24 GMT

Sum({$<Insurer = {InsurerA}>}1)

Sum(Total{$<Insurer = {InsurerA}>}1)

Regards

Thu, 26 Mar 2015 12:59:51 GMT

Thank you Manish and Max for your suggestions, but unfortunately they haven't worked.

I'm starting to think that there may be a problem with the way I have collated my data!

MK_QSL — Thu, 26 Mar 2015 13:02:22 GMT

Try any of below and let me know ...

Count({<Insurer = {'InsurerA'}>}Insurer)/Count(TOTAL {<Insurer = {'InsurerA'}>}Insurer)

Count({<Insurer = {'InsurerA'}>}Insurer)/Count(ALL {<Insurer = {'InsurerA'}>}Insurer)

Count({<Insurer = {'InsurerA'}>}Insurer)/Count(TOTAL Insurer)

Count({<Insurer = {'InsurerA'}>}Insurer)/Count(ALL Insurer)

Thu, 26 Mar 2015 13:07:53 GMT

Count({<Insurer = {'InsurerA'}>}Insurer)/Count(TOTAL {<Insurer = {'InsurerA'}>}Insurer) - worked perfectly!

Thank you so much for your help!