Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Calculating Percentage from two expressions

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

1 Reply
Not applicable

Re: Calculating Percentage from two expressions

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

Community Browser