Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How can i change decimal point value into whole value

Hi Friends,

I want to change decimal point value into whole value in text box. When I create the expression in a text box for show percentage of some field, it shows me like this "55.98745". But I need to show it like "56". Can you please help me how to do in a expression.

And my expression  is   "=(Count([Product A])/Count([Total Product]))*100"

1 Solution

Accepted Solutions

Re: How can i change decimal point value into whole value

=Round((Count([Product A])/Count([Total Product]))*100)

3 Replies

Re: How can i change decimal point value into whole value

=Round((Count([Product A])/Count([Total Product]))*100)

Not applicable

Re: How can i change decimal point value into whole value

Marco its awesome and thank you very much

Re: How can i change decimal point value into whole value

you're welcome

regards

Marco

Community Browser