Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

%

Hi All,

We are creating a "Text Object" in one of our application.

The expected output from the text object is to show the percentage of conversion ratio.

We are using the following expression in the General tab of the Text Object

=num((count(Conversion='Yes') / Count(Patient Code) * 1),'##0 %;(##0)')

Howver, this expression is not yielding any result

Please find the attached file for the same.

1 Solution

Accepted Solutions
sivarajs
Specialist II
Specialist II

num((count(if(Conversion='Yes',Conversion)) / Count([Patient Code]) * 1),'##0 %;(##0)')

View solution in original post

2 Replies
sivarajs
Specialist II
Specialist II

num((count(if(Conversion='Yes',Conversion)) / Count([Patient Code]) * 1),'##0 %;(##0)')

Not applicable
Author

Bulls EYE !!!!!