Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

How to show value in percentage format

Hi Experts,

Can any one please help me to show the value in percentage format 

My expression is

(Sum(Sales)/Sum(Products))*100

I am getting results like 20,30,40.. I have to show these values in 20%,30%,40% in expression editor using num format instead of default number formats.

I have tried like below

Num((Sum(Sales)/Sum(Products))*100,'#,##0%') but its not working.

Please help me on this.

Thanks in advance.

1 Solution

Accepted Solutions
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi Mahitham

You are multiplying the fraction by 100 and then formatting it as a percentage (which multiplies it by 100 and add the % in the UI). Try Num((Sum(Sales)/Sum(Products)),'#0%').

Good luck.

Mauritz

View solution in original post

2 Replies
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi Mahitham

You are multiplying the fraction by 100 and then formatting it as a percentage (which multiplies it by 100 and add the % in the UI). Try Num((Sum(Sales)/Sum(Products)),'#0%').

Good luck.

Mauritz

Channa
Specialist III
Specialist III

just remove *100

in number format set as %

Channa