topic Re: Number still showing decimals in QlikView

Number still showing decimals

Anonymous — Tue, 05 Jul 2016 10:05:56 GMT

Hi everyone,

I have created a bat chart, where I put is some quantities. In the chart properties, I have selected to display these quantities as 'Integer' in the 'Numbers' tab when the .

Nevertheless, the bar graph still shows decimals when all quantities equal zero (see attached print screens). I have tried to get rid of the decimals by using the Round() function, but it did not help.

Any suggestions ?

Re: Number still showing decimals

ThornOfCrowns — Tue, 05 Jul 2016 10:07:26 GMT

Could you show an example of your QVW?

Re: Number still showing decimals

Anonymous — Tue, 05 Jul 2016 10:12:51 GMT

Hi James,

Attached, my QVW file.

Re: Number still showing decimals

vardhancse — Tue, 05 Jul 2016 10:13:32 GMT

Hi,

In expression give the number format required some thing similar to below.

Sum(Amount)

Change to:

Num(Sum(Amount),'##')

In chart properties number tab->Expression default

Re: Number still showing decimals

arasantorule — Tue, 05 Jul 2016 10:17:53 GMT

Hi,

Can you check if the below resolves.

Thanks

Re: Number still showing decimals

ThornOfCrowns — Tue, 05 Jul 2016 10:25:28 GMT

Hi, thanks for the file.

I don't understand what you're trying to achieve, though.

Your bars all have values to the 4th decimal place and showing them as integers just cuts off the shown value to -0, the bars will remain the same size etc. The table shows the values to 6 decimal places when you remove the 'show as integer' value.

If you set the table values back to default, you get:

You do not have zero values and so the calculations are not zero.

Re: Number still showing decimals

jonas_rezende — Tue, 05 Jul 2016 12:59:07 GMT

Hi, Duchateau Filip.

Use the keyboard about bar chart Ctrl+Shift+button left of mouse and drag on the comma. See figure below.

Hope this helps!

Re: Number still showing decimals

Anonymous — Tue, 05 Jul 2016 14:11:32 GMT

Hi,

Thanks to all of you for your suggestions.

I have solved the problem by rounding the quantities in my load script. Now, the bar chart shows a flat line on the X-axis when all quantities are close to zero, which is what I needed.