topic Get a percentage in a calculated field in QlikView

Get a percentage in a calculated field

Adforma — Wed, 25 Nov 2020 16:16:04 GMT

Hello to all
Help: 😱

The expression: = num (Sum ({<Year = {$ (= Max (Year))}>} Amount),) / num (Sum ({<Year = {$ (= Max (Year) -1)}>} Amount) * (1+ (Budget))) * 100 gives me the result: 54,57820 ...
I want to get 58.78%, but I don't understand how and where to put in the right syntax the expression percentage: '#, ## 0.00%' with the right parentheses.
Can you help me?
Thanks in advance ...
Luigi

Re: Get a percentage in a calculated field

Vegar — Sun, 15 Sep 2019 08:10:35 GMT

Firstly: You are multiplying by 100 which transforms your 0.58 (58%) into 58 (5800%)

Secondly: you only need one NUM() in the whole expression, a NUM() that is wrapping the whole expression.

Thirdly: if you need help with the fact that you are getting the value 54 but expect the value 58 then you will probably need to provide us with more information.

Good luck

Re: Get a percentage in a calculated field

Adforma — Sun, 15 Sep 2019 08:36:54 GMT

Thanks Vegar for the answer.
I was searching something as this:
=num(Sum({<Year={$(=Max(Iear))}>} Revenue),'#.##0,00 €')
that f.i. give me this: 4.500,00 €
but in my expression:
=num(Sum({<Year={$(=Max(Year))}>} Revenue),)/num(Sum({<Year={$(=Max(Year)-1)}>} Revenue)*(1+(Budget)), '#,##0.00%')
the Expressionis OK but the string
'#,##0.00%'
unfortunately is ininfluent.

Thanks in advance

Luigi

Re: Get a percentage in a calculated field

Vegar — Sun, 15 Sep 2019 12:59:56 GMT

If the expression is correct then you're almost there, you just need to get the formatting correct.

If it's not working for you like you wrote then you might need to make use of the second and third parameters in the num function (the delimiters). Take a look at the help page for info: https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/FormattingFunctions/Num.htm

Sometimes it's just as easy to do the number formatting in the chart object properties. You could give that approach a go as well.

Good luck

Re: Get a percentage in a calculated field

StarinieriG — Mon, 16 Sep 2019 08:03:10 GMT

Hi,

try to use num only once:

num(
Sum({<Year={$(=Max(Year))}>} Revenue)
/
Sum({<Year={$(=Max(Year)-1)}>} Revenue)*(1+(Budget))

, '#,##0.00%')

Re: Get a percentage in a calculated field

Vegar — Mon, 16 Sep 2019 09:15:21 GMT

It looks like @StarinieriG expression should work, but I'm just concerned about your final product (1+(budget))

Are you aware that you only get an value from budget when you have a single value per dimension combination in your chart?

(1 + (budget)) is equvivalent to (1 + only(budget))

Re: Get a percentage in a calculated field

Brett_Bleess — Thu, 26 Sep 2019 13:34:41 GMT

Bergamo, did the last posts get you what you needed, or are you still working on things? If the posts did help, please use the Accept as Solution button to mark the one(s) that got you what you needed. If you did something else, please consider posting that and then mark that as the solution for future visitors, and if you are still working on things, leave an update as to where you stand.

Regards,
Brett