Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Percentage formatting

hi,

i have table as follows:

order value1
order value 2total_sales_value
15087

505

6499600
8145700

and i am getting output like:

sales %
469.3
271.6
180

i am using formula as - (order value1+order value2)/total_sales_value*100

here i am getting percentage format as shown in table i.e 469.3% using 12.3% number formatting also using 12% number formatting ans is - 469%.

but actual expected ans is 46.93%

how to solve this condition?

6 Replies
Partner
Partner

Re: Percentage formatting

use expression as

(order value1+order value2)/total_sales_value

Don't multiply it by 100.

Not applicable

Re: Percentage formatting

will it give percentage value without multiplying by 100????

Highlighted
Partner
Partner

Re: Percentage formatting

yes..

Partner
Partner

Re: Percentage formatting

PFA

Not applicable

Re: Percentage formatting

Attachment

Partner
Partner

Re: Percentage formatting

Try now