# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for
Did you mean:
Highlighted
Master III

## Get values in percentage

Hi,

i used below code to get values in percentage

,'#,##0%')

but this what i get

106,080,500,56%

what i am doing wrong here i used num function

and Total also

plz suggest something

thanks

25 Replies
Highlighted
Master III

## Re: Get values in percentage

formula is

A= num(sum({<ACNT_FLEX_02={'Balance Sheet'}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1)

Percentage  = (A+B)/B*100

Highlighted

## Re: Get values in percentage

Hi,

In your expression either multiple by 100 or just use

NUM((A+B)/B,'#,##0%')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Master III

## Re: Get values in percentage

Hi max,

plz check first code i multiplied by 100. and i need to show this in a text object

Highlighted

## Re: Get values in percentage

Hi,

In first expression you are multiplying by 100 as well as formating the output with num(Expre,'#,##0%')

Try below

,'#,##0%')

or

,'#,##0')&' %'

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Master III

## Re: Get values in percentage

Hi max,

No luck only blank value

thanks

Highlighted
Master III

## Re: Get values in percentage

any suggestion guys?

Highlighted
Creator II

## Re: Get values in percentage

You lost me, what do you want to achieve?

Are you sure you don't want (B-A)/B? Percentage is basically Part/Whole not (Part+Whole)/Whole.

Give the number for A and B instead of the expression and try it.

Highlighted
Master III

## Re: Get values in percentage

sorry (A-B)/A*100

Highlighted
Master III

## Re: Get values in percentage

i did this (A-B)/A*100

but the result is like this 106,080,500,56%

why?

thanks