topic Re: Adding percentges together but getting a decimal in QlikView

Adding percentges together but getting a decimal

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

Hi Guys

I want to add up percentages as seen below but when I go to add I'm getting the decimal point rather than percentage if that makes sense.

So for example instead of returning 9.18% (total of both) it is returning 0.918.

I know it probably the code I need to change?

Any Ideas

Thanks Martin

Re: Adding percentges together but getting a decimal

sunny_talwar — Fri, 02 Nov 2018 12:51:21 GMT

Is it giving you 0.918 or 0.0918? Because a decimal representation of 9.18% will be 0.0918. If this is what you see, then all you need is a Num function around your expression

Num(Expression, '#.##%')

Re: Adding percentges together but getting a decimal

sweens78 — Fri, 02 Nov 2018 12:55:01 GMT

Hi Sunny apologies I never included the below, Im still getting the decimal point

=Num((count(if (SelfHarmAct_ID= '1' and SubstanceMisuseAlsoAFactor = '1', NEWKEYID))-Count(if (SelfHarmAct_ID = '1' and SubstanceMisuseAlsoAFactor= '1', PatientsNotAssessed_ID)))/(Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.##%')
+Num((count(if (SelfHarmAct_ID= '2' and SubstanceMisuseAlsoAFactor = '1', NEWKEYID))-Count(if (SelfHarmAct_ID = '2' and SubstanceMisuseAlsoAFactor= '1', PatientsNotAssessed_ID)))/(Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.##%')

Re: Adding percentges together but getting a decimal

sunny_talwar — Fri, 02 Nov 2018 13:01:30 GMT

Try this

=Num(

((Count({<SelfHarmAct_ID = {'1'}, SubstanceMisuseAlsoAFactor = {'1'}>} NEWKEYID) - Count({<SelfHarmAct_ID = {'1'}, SubstanceMisuseAlsoAFactor = {'1'}>} PatientsNotAssessed_ID))/(Count(NEWKEYID) - Count(PatientsNotAssessed_ID))
+

(Count({<SelfHarmAct_ID = {'2'}, SubstanceMisuseAlsoAFactor = {'1'}>} NEWKEYID) - Count({<SelfHarmAct_ID = {'2'}, SubstanceMisuseAlsoAFactor = {'1'}>} PatientsNotAssessed_ID))/(Count(NEWKEYID) - Count(PatientsNotAssessed_ID)))

,'##.##%')

Re: Adding percentges together but getting a decimal

sweens78 — Fri, 02 Nov 2018 13:06:15 GMT

Sunny what can I say,

Brilliant that's working!

Martin

Re: Adding percentges together but getting a decimal

sunny_talwar — Fri, 02 Nov 2018 13:11:42 GMT

Awesome

Re: Adding percentges together but getting a decimal

sweens78 — Fri, 02 Nov 2018 13:15:39 GMT

Sunny apologies If I was to add another line as below, am I wrong with my brackets?

=Num(

((Count({<SelfHarmAct_ID = {'1'}, SubstanceMisuseAlsoAFactor = {'1'}>} NEWKEYID) - Count({<SelfHarmAct_ID = {'1'}, SubstanceMisuseAlsoAFactor = {'1'}>} PatientsNotAssessed_ID))/(Count(NEWKEYID) - Count(PatientsNotAssessed_ID))
+

(Count({<SelfHarmAct_ID = {'2'}, SubstanceMisuseAlsoAFactor = {'1'}>} NEWKEYID) - Count({<SelfHarmAct_ID = {'2'}, SubstanceMisuseAlsoAFactor = {'1'}>} PatientsNotAssessed_ID))/(Count(NEWKEYID) - Count(PatientsNotAssessed_ID)))
+
(Count({<SelfHarmAct_ID = {'2'}, SubstanceMisuseAlsoAFactor = {'1'}>} NEWKEYID) - Count({<SelfHarmAct_ID = {'2'}, SubstanceMisuseAlsoAFactor = {'1'}>} PatientsNotAssessed_ID))/(Count(NEWKEYID) - Count(PatientsNotAssessed_ID)))

,'##.##%')

Re: Adding percentges together but getting a decimal

sunny_talwar — Fri, 02 Nov 2018 13:19:12 GMT

Yes... try this

=Num(
(

(Count({<SelfHarmAct_ID = {'1'}, SubstanceMisuseAlsoAFactor = {'1'}>} NEWKEYID) - Count({<SelfHarmAct_ID = {'1'}, SubstanceMisuseAlsoAFactor = {'1'}>} PatientsNotAssessed_ID))/(Count(NEWKEYID) - Count(PatientsNotAssessed_ID))
+
(Count({<SelfHarmAct_ID = {'2'}, SubstanceMisuseAlsoAFactor = {'1'}>} NEWKEYID) - Count({<SelfHarmAct_ID = {'2'}, SubstanceMisuseAlsoAFactor = {'1'}>} PatientsNotAssessed_ID))/(Count(NEWKEYID) - Count(PatientsNotAssessed_ID))
+
(Count({<SelfHarmAct_ID = {'2'}, SubstanceMisuseAlsoAFactor = {'1'}>} NEWKEYID) - Count({<SelfHarmAct_ID = {'2'}, SubstanceMisuseAlsoAFactor = {'1'}>} PatientsNotAssessed_ID))/(Count(NEWKEYID) - Count(PatientsNotAssessed_ID))

)
,'##.##%')