Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
Highlighted
MVP
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)

View solution in original post

5 Replies
MVP
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
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)

View solution in original post

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!