topic Re: Display % correctly in input box in QlikView

Display % correctly in input box

Wed, 23 Sep 2015 19:52:49 GMT

I have an input box where users can input a desired percent (%) and it gets set to a variable. The variable is then used to calculate another variable to be used in a chart. The issue is when inputting a number, for example = 25, it displays 2500% instead of 25%. How can I change this without requiring users to put in .25?

Re: Display % correctly in input box

pamaxeed — Wed, 23 Sep 2015 20:10:31 GMT

Why you not use just an other format for example number with 2 decimals?

Re: Display % correctly in input box

sinanozdemir — Wed, 23 Sep 2015 20:12:01 GMT

Hi Shana,

I usually follow the below format:

Thanks

Re: Display % correctly in input box

pamaxeed — Wed, 23 Sep 2015 20:13:47 GMT

I mean in the Inputbox you can define a format, so in that case u just have to do like that:

Re: Display % correctly in input box

Wed, 23 Sep 2015 20:49:34 GMT

I did change the format like that and I clicked the show in percent % at the bottom. the number shows as 2500% instead of 25%

Re: Display % correctly in input box

Wed, 23 Sep 2015 20:50:08 GMT

Re: Display % correctly in input box

Wed, 23 Sep 2015 20:50:32 GMT

Re: Display % correctly in input box

Wed, 23 Sep 2015 20:51:52 GMT

it's not the text object that is displaying it incorrectly, it's the input box.

Re: Display % correctly in input box

pamaxeed — Wed, 23 Sep 2015 21:05:13 GMT

Here a sample app...

Try to give a look.

Cheers,

Patric

Re: Display % correctly in input box

Wed, 23 Sep 2015 21:39:58 GMT

I see what you're doing. The issue is that I want it to display the correct % in the input box, not an additional text object. I want this to say 33% not 33.00 in the input box.

Re: Display % correctly in input box

settu_periasamy — Thu, 24 Sep 2015 03:56:21 GMT

May be you can try with Variable event trigger like attached

Re: Display % correctly in input box

Thu, 24 Sep 2015 15:10:21 GMT

Thank you Settu!! This got me a lot closer.. I left off the &'%' in the trigger because it would add a second one when I changed the number again but I was able to use the trigger to get what I needed and then check the % box in the input box number tab and it is now working as I would like