Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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????

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