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: 
Anonymous
Not applicable

Doubt in Straight table in Qlik sense

Hi,

I want to make a straight table for showing the region wise profit percentage of sample superstore dataset in Qlik Sense but i am unable to do that so can you please suggest me what code should i write to calculate the profit percentage.

20 Replies
vinieme12
Champion III
Champion III

Num( YourExpression , '##.0%')

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

It didn't work

vinieme12
Champion III
Champion III

in the formatting section select "Custom"

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

I have also tried it but didn't work

devarasu07
Master II
Master II

Hi,

refer below screen shot, going forward if you have any report issues/doubt try make mock data with sample document/app then others can quickly understand u r issues. Tks

12.jpg

Anonymous
Not applicable
Author

This is also not working..Capture.PNG

Anonymous
Not applicable
Author

this works but i didn't get any % sign.Capture1.PNG

vinieme12
Champion III
Champion III

##.0%

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
devarasu07
Master II
Master II

in your custom format, try like below,

0.0% or (#,##0.0% )

(if still not working share your expression or your app with sample data) will check and let u know. tks

11.jpg11.jpg

Anonymous
Not applicable
Author

Thanks Devarasu, now it is working.