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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need Decimal

=Sum(num_leads)  / Sum(num_users).  I have this expression.  Right now it returns 1 but I need it to be 1.25 and can't get it to show me the decimal value. 

Any suggestions?

1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi,

You can use this : NUM(Sum(num_leads)  / Sum(num_users),'0.00')

Regards,

Sokkorn Cheav

View solution in original post

3 Replies
Not applicable
Author

In properties,there is a sheet "number". You can set 2 decimal here.

Sokkorn
Master
Master

Hi,

You can use this : NUM(Sum(num_leads)  / Sum(num_users),'0.00')

Regards,

Sokkorn Cheav

Not applicable
Author

num(Sum(num_leads)  / Sum(num_users),'#0,00')