topic Re: toggle between % and units in QlikView

toggle between % and units

yelin_nyu — Fri, 05 Apr 2013 15:33:31 GMT

I created 2 buttons. one is in units, and another is for percentage. when i click on units, my charts should show units, when i click on %, it should show %. but I am unable to get % working. the num() only allow me use % or not

thanks

Re: toggle between % and units

Anonymous — Fri, 05 Apr 2013 15:41:32 GMT

if it is chart use properies and go to number tab and select the number format option avaiable

hope it helps

Thanks

Re: toggle between % and units

sushil353 — Fri, 05 Apr 2013 16:45:24 GMT

Hi,

Try this:

create a variable say vUnit

in the chart expression do something like:

=if(vUnit=1,num(Value/100,'##0%'),Value).

now just toggle the value of vUnit using your buttons

HTH

Sushil

Re: toggle between % and units

yelin_nyu — Fri, 05 Apr 2013 16:47:31 GMT

Yes, i did that but the problem is if i select integer or number, I get decimal points for %, if i use percentage in number tab, i get % for units. i tried to use num() function in expression, but couldn't over write the setting in Number tab.

Re: toggle between % and units

yelin_nyu — Fri, 05 Apr 2013 16:53:18 GMT

I just tried this. but couldn't get % sign to appear. it made my values 9.87, without % . shall i use num#()

Re: toggle between % and units

yelin_nyu — Fri, 05 Apr 2013 17:01:33 GMT

I fixed the problem by using default expression from number so when i use num() to format the expression, it will work.