Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Facing a problem to show a calcualtion in % format in text area

Hi guys,

this is the calculation which i am doing to calculate sales vs target

(($(YtdNetSalesGoldDetailGrossWeight)-$(YtdNetSalesGoldDetailStoneWeight))/($(YtdTotalGOldWt)*$(AvgCurYear)))

$(YtdNetSalesGoldDetailGrossWeight)-$(YtdNetSalesGoldDetailStoneWeight))=4226231.30

$(YtdTotalGOldWt)=706.033

$(AvgCurYear)=96





I wan to show the ouput in text area like this format 61.03% but i am getting 6103.33 output


Pls help me all



Thanks in advance





1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

in a atable you can define the number Format in the number tab

in a textobject you Need to Format the dataformat

like num(your Expression,'#.##0,0%')

if the number is to hight you Need to divide by 100

View solution in original post

11 Replies
Anonymous
Not applicable
Author

in a atable you can define the number Format in the number tab

in a textobject you Need to Format the dataformat

like num(your Expression,'#.##0,0%')

if the number is to hight you Need to divide by 100

MK_QSL
MVP
MVP

=Num(($(YtdNetSalesGoldDetailGrossWeight)-$(YtdNetSalesGoldDetailStoneWeight))/($(YtdTotalGOldWt) * $(AvgCurYear)),'#0.0%')

Frank_Hartmann
Master II
Master II

try

=num(frac(expression),'##.###,##%')

Not applicable
Author

i followed your answer and getting 6130.00 answer

but when i divided by 100 then i got 0.613099 as answer

Not applicable
Author

6130.99 as answer

Frank_Hartmann
Master II
Master II

try


=num(frac(expression),'##,###.##%')


or set in script:

SET ThousandSep='.';

SET DecimalSep=',';

and use:

=num(frac(expression),'##.###,##%')

Not applicable
Author

i need to get 61.30% as answer

kkkumar82
Specialist III
Specialist III

Is it possible to share a sample app by reducing some of the data

gopi_pattepuram
Contributor II
Contributor II

try this

=num((($(YtdNetSalesGoldDetailGrossWeight)-$(YtdNetSalesGoldDetailStoneWeight))/($(YtdTotalGOldWt)*$(AvgCurYear)))/100,'#,##0.00%')