topic Re: Input box concat in QlikView

Input box concat

shree909 — Thu, 26 Jul 2012 19:37:17 GMT

Hi,

i have a input box in which user enters the value, after entering the value it should get appended with % at the end.

for example: if user enters 0.12 it should show as 0.12%

i tried changed the number format taking percent but it shows 12% instead of 0.12 %

what ever the user enters the value it is stored in a variable.

can anyone reply to this post..

Thanks

Re: Input box concat

CELAMBARASAN — Thu, 26 Jul 2012 20:25:11 GMT

Check document settings -->triggers-->Variables-->on Change action

Re: Input box concat

shree909 — Thu, 26 Jul 2012 20:42:43 GMT

thanks its working for the input box, the problem is whatever i enter in the input box that has to be multipled by some fact and it will display the result.

if i use the above function i can only enter the data but i dont find the calculated fact in other text box..

Re: Input box concat

CELAMBARASAN — Thu, 26 Jul 2012 20:51:27 GMT

What calculation you performed?

Re: Input box concat

shree909 — Thu, 26 Jul 2012 21:36:16 GMT

This is the fact that has to be multipled like vpercent. after multiplying i need to round the value to 2 decimals

the problem i notice ,when i enter the value in the input box its not getting multiplied, it showing -(blank)

= ((num(($(eCompany1) * $(eCompany2) + $(ecompetitor1) * $(ecompetitor2)),'#,##0.00')*$(vPercent))/100)

Re: Input box concat

MayilVahanan — Thu, 26 Jul 2012 21:49:01 GMT

Try like this

= (num(($(eCompany1) * $(eCompany2) + $(ecompetitor1) * $(ecompetitor2)),'#,##0.00') * vPercent)/100

Hope it helps

Re: Input box concat

shree909 — Fri, 27 Jul 2012 03:06:58 GMT

thanks guys i could able to find the solution...

Re: Input box concat

shree909 — Fri, 27 Jul 2012 04:23:35 GMT

Is there any way that we can increase the size of the input box???

when i increase the font size it gets changed, i dont want to use the caption to increase the size.