topic Re: round up thousand indicator when click on a button? in QlikView

round up thousand indicator when click on a button?

oliviatww — Mon, 22 Sep 2014 20:57:58 GMT

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

Re: round up thousand indicator when click on a button?

ecolomer — Mon, 22 Sep 2014 21:07:46 GMT

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

Re: round up thousand indicator when click on a button?

oliviatww — Mon, 22 Sep 2014 21:19:07 GMT

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.

Re: round up thousand indicator when click on a button?

Mon, 22 Sep 2014 21:20:43 GMT

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

Re: round up thousand indicator when click on a button?

oliviatww — Mon, 22 Sep 2014 21:34:09 GMT

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.

Re: round up thousand indicator when click on a button?

Mon, 22 Sep 2014 21:42:08 GMT

Could you post a sample example??

Re: round up thousand indicator when click on a button?

oliviatww — Tue, 23 Sep 2014 20:04:13 GMT

Hi Kuruthi,

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