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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
shree909
Partner - Specialist II
Partner - Specialist II

Input box concat

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

Labels (1)
1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

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

View solution in original post

7 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

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

shree909
Partner - Specialist II
Partner - Specialist II
Author

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..

CELAMBARASAN
Partner - Champion
Partner - Champion

What calculation you performed?

shree909
Partner - Specialist II
Partner - Specialist II
Author

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)

MayilVahanan
MVP
MVP

Hi

     Try like this

    

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

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
shree909
Partner - Specialist II
Partner - Specialist II
Author

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

shree909
Partner - Specialist II
Partner - Specialist II
Author

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.