topic Re: Turning a formula into a % in a text box in QlikView

Turning a formula into a % in a text box

Mon, 01 Jun 2015 14:34:36 GMT

Hi,

I have various text boxes on my dashboard with calculations in them. I have some that are percentages but i cant format them correctly.

This is an example:

left(1-(sum({$<Metric_Part={'Num'}, Metric_Code={'RTT24'}>} Metric_Value)
/sum({$<Metric_Part={'Den'}, Metric_Code={'RTT24'}>} Metric_Value ) )

,4 ) & '%'

Rather than 'left' what can i sue to be more accurate, i was thinking a 'round' function? and also the above calculation brings out 0.76%, when i need it to say 76%.

Thanks,

Re: Turning a formula into a % in a text box

marcus_sommer — Mon, 01 Jun 2015 14:37:18 GMT

You could use something like num(value, '#.##0,0%').

- Marcus

Re: Turning a formula into a % in a text box

Mon, 01 Jun 2015 14:39:06 GMT

Sorry - i dont understand. Where do i put that in my formula?

Re: Turning a formula into a % in a text box

marcus_sommer — Mon, 01 Jun 2015 14:42:03 GMT

num(1-(sum({$<Metric_Part={'Num'}, Metric_Code={'RTT24'}>} Metric_Value)
/sum({$<Metric_Part={'Den'}, Metric_Code={'RTT24'}>} Metric_Value ) ) , '#.##0,0%')

Re: Turning a formula into a % in a text box

maxgro — Mon, 01 Jun 2015 14:49:20 GMT

If your expression (I'll call exp) is

EDIT: added 1-(...)

1- (

sum({$<Metric_Part={'Num'}, Metric_Code={'RTT24'}>} Metric_Value) /

sum({$<Metric_Part={'Den'}, Metric_Code={'RTT24'}>} Metric_Value )

)

To format your expression use num function, the format could be #.##0%

num(exp, '#.##0%')

To get the right format (bold), open the number tab in a chart, try the different format and when it's correct copy the format pattern

Re: Turning a formula into a % in a text box

jagan — Mon, 01 Jun 2015 14:52:08 GMT

Hi,

Format the numbers using Num() like below

=Num(1-(sum({$<Metric_Part={'Num'}, Metric_Code={'RTT24'}>} Metric_Value)
/sum({$<Metric_Part={'Den'}, Metric_Code={'RTT24'}>} Metric_Value ) ), '#,##0.0%')

Hope this helps you.

Regards,

Jagan.

Re: Turning a formula into a % in a text box

Mon, 01 Jun 2015 15:05:04 GMT

Thanks - that has worked

Re: Turning a formula into a % in a text box

jagan — Tue, 02 Jun 2015 06:07:48 GMT

Hi,

If you got the answer please close this thread by giving correct and helpful answers to the useful posts, so that it would help others in finding the answers for similar type of questions.

Regards,

Jagan.