topic Re: Percentage showing up wrong in QlikView

Percentage showing up wrong

Fri, 28 Aug 2015 05:23:45 GMT

Hi all,

I am encountering a weird problem whereby some of my percentages are showing up in an odd way. I was using QlikView personal edition and everything was ok, but now when I am moving it into the testing environment and onto the web, the data has been transformed in a way that the same formulas are not showing up in the same way. For example, see below, where for "TOPSIDES" it should show 100%:

Another way this same problem is showing itself is that some percentages are showing up fine (such as the 0% above), but other when I filter on other things, seem to have been altered by a factor of 10. As such 82% is showing up as 8.2%. FYI, the object is a Text Object with a formula in it. Example below:

=NUM( (SUM({<BLART={'K1','K2','K3','K4','KR'}, [BA Name]*={'Topsides'}, BUZEI={'001'}>}#ActualNetSpend_NOK) + SUM({<BLART={'KA'}, [BA Name]*={'Topsides'}>}#ActualNetSpend_NOK)) / (SUM(TOTAL{<BLART={'K1','K2','K3','K4','KR'}, BUZEI={'001'}>}#ActualNetSpend_NOK) + SUM(TOTAL{<BLART={'KA'}>}#ActualNetSpend_NOK)),'#,#%')

Has anyone encountered this problem before? Hope someone can help!

Re: Percentage showing up wrong

hic — Fri, 28 Aug 2015 06:25:53 GMT

I suspect a problem around the decimal separator. (It could be different on your local machine compared to your server.) Try using all four parameters of Num() so that both the decimal separator and thousand separator are clearly defined.

Also, test '0%' or '#%' instead of '#,#%' as format code.

HIC

Re: Percentage showing up wrong

Mon, 31 Aug 2015 07:26:18 GMT

Sorry I haven't set this as a correct answer yet. There is an access problem on my server so I cannot even access the file right now. I will set your answer as correct and make a new question if it turns out not to help as soon as the problems are fixed. Thanks for your response Henric