# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

## Percentage of Total Set Analysis

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:

ReasonNo of Enquiries SentPercentage
Total3100%
No Quote133.33%
Quoted & Won133.33%
Quoted & Lost133.33%

Expression behind No of Enquiries Sent:

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

Can anyone suggest an expression for the percentage column?

Thank you

Tags (3)
1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Percentage of Total Set Analysis

Try any of below and let me know ...

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

or

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

or

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

or

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

5 Replies
Highlighted
MVP

## Re: Percentage of Total Set Analysis

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

or

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

Highlighted

## Re: Percentage of Total Set Analysis

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

/

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Not applicable

## Re: Percentage of Total Set Analysis

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!

Highlighted
MVP

## Re: Percentage of Total Set Analysis

Try any of below and let me know ...

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

or

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

or

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

or

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

Highlighted
Not applicable

## Re: Percentage of Total Set Analysis

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

Thank you so much for your help!