Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Column values%

Someone knows how to display the values as% of the column?

Thanks

5 Replies
oknotsen
Master III
Master III

Change the expression to:

sum(theMeasure) / sum(TOTAL theMeasure)

... and change the display to percentage

May you live in interesting times!
reddy-s
Master II
Master II

Hi Robert,

I am assuming that you already have the values of the measure ranging from 0 and 1.(Ex: 0.46 = 46%)

In this case, in the properties panel->under the measure properties->you will find formation option turn that off and under that select Number-> in the drop down select the % format which you wanted to apply. You can do most of the number formatting using these settings.

Thanks,

Sangram

reddy-s
Master II
Master II

Check this Image:

2016-01-25 01_05_51-Qlik Sense Desktop.png

ogster1974
Partner - Master II
Partner - Master II

ONnos solution will work and sangrams formatting will make it look good.  I've always found a nice pie chart ideal for that kind of requirement.

Not applicable
Author

Very usefull, thanks!!!