Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
oliviatww
Partner - Contributor II
Partner - Contributor II

round up thousand indicator when click on a button?

Hi there,

Wondering is that possible to round up number from 46000 to 50000 or 53000 to 50000 when user click on a button?

Any help is appreciated. THANKS

6 Replies
ecolomer
Master II
Master II

Yes it is possible with the function ROUND or CEIL par example:

P00.png

oliviatww
Partner - Contributor II
Partner - Contributor II
Author

Thanks for your reply Enrique.

Actually what I want is to allow user to click on the button, then round up all the numbers in my application including those one under expression or variables etc.

Not applicable

You can bring the field values into  a listbox and set a conditional expression like below with a variable change.

=round(FieldName/10000)*10000 (In listbox expression)

Set the variable to button click event, so when the button is clicked, the variable changes to make the expression run and the list box values changes to is its round of values.

Hope it helps!!

Kiru

oliviatww
Partner - Contributor II
Partner - Contributor II
Author

Thanks for your reply too Kiruthi.

Actually I'm not using fields but instead expression. I have got more than one expression so if I got 100 then it going to takes lots of time.

Not applicable

Could you post a sample example??

oliviatww
Partner - Contributor II
Partner - Contributor II
Author

Hi Kuruthi,

Thanks for your reply. I got that work already. Thanks a lot.