topic Trouble with Values on Data Points in QlikView

Trouble with Values on Data Points

Fri, 06 Feb 2015 22:00:46 GMT

Can anyone explain why I'm having problems with this bar chart? It's very basic and is working perfectly except for one thing. Notice in 2013 the data point is showing ($0). Obviously, this isn't the case and I can't figure out why it's not working. This chart is set for Full Accumulation and the individual categories are correct when I hover over them. I'm guessing it has to do with the 'Securities Lending Collateral' Dimension which does accumulate to $0 in 2013, I just don't know why the chart can't display the correct total taking all of the categories into consideration. Any help would be appreciated. Thanks!

-J D.

Re: Trouble with Values on Data Points

Anonymous — Fri, 06 Feb 2015 22:26:04 GMT

Could you please sent the app asap then I can check.

Re: Trouble with Values on Data Points

Tue, 10 Feb 2015 23:31:33 GMT

I'm not seeing how I can send this to you or attach it in the thread.

Re: Trouble with Values on Data Points

Anonymous — Wed, 11 Feb 2015 01:18:20 GMT

when you click on reply, you will see USE ADVANCED EDITOR on the top right corner. Click the button and then go to the next window. There you will find attach option on bottom right corner. You can attach there your app.

Re: Trouble with Values on Data Points

robert_mika — Wed, 11 Feb 2015 04:33:41 GMT

What's the individual values for 2013?

I see that y axis has value -50 000 000

There is 5 Category in Legend but only 4 shown on chart.

If this is Full accumulation should not 2012 be higher that 2011.

Check your data source and add up you values there.

lastly post your data(not file) I'm working on Personal Edition

Re: Trouble with Values on Data Points

Wed, 11 Feb 2015 15:29:57 GMT

Totals cumulative for 2013:

Securities Lending 0

Beneficial Interest 43,697,448

Other 973,734

Receivables 50,906,407

Cash & Investments 518,983,190

The value on the Data Point should be 614,560,779 based on those numbers, not 0.

The totals for activity in 2013 (not cumulative) are:

Securities Lending -5,171,649

Beneficial Interest -928,388

Other 4,965

Receivables 57,288

Cash & Investments 25,693,095

I'm assuming the -50 000 000 is appearing due to the fact there are negative values in each individual year.

The reason it appears only 4 categories are showing is the "Other" category values are so small compared to the others they are not visible. They are indeed represented in the chart.

There are negative values greater than the prior year from 2011 to 2012 which is why 2012 is less. It is calculating correctly.

Re: Trouble with Values on Data Points

Wed, 11 Feb 2015 15:33:18 GMT

Sorry QlikRajan, this is all I see when I click Reply...I don't see USE ADVANCED EDITOR anywhere.

Re: Trouble with Values on Data Points

robert_mika — Wed, 11 Feb 2015 15:52:12 GMT

A suggestion:

Try to play with the Accumulate "Steps Back" to see if you got the same problem.

The brackets on 0 suggest negative value in that bar not 0 itself.