Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating Percentage from two expressions

Hi,

I have two separate expressions as below:

=count(callref), which gives me the total amount of calls.

=count({$<[withinfix]={0}>} withinfix), which gives me the total amount of calls where field withinfix equals 0.

What I am looking to do is create and expression in a text box to show the percentage between the field with the total amount of calls and the field where withinfix equals 0.

I have tried the below expression with no luck.  Would someone be able to help please?

=sum(count(callref) / (count({$<[withinfix]={0}>} withinfix))) * 100

However this shows a NULL Value.

Regards,

Jon Ditchfield

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

Please dont waste your time on this one, I have managed to figure it out.

The calculation is: =count([$<[withinfix]={0}>} withinfix) / count(callref) * 100

View solution in original post

1 Reply
Not applicable
Author

Hi,

Please dont waste your time on this one, I have managed to figure it out.

The calculation is: =count([$<[withinfix]={0}>} withinfix) / count(callref) * 100