topic Re: Values on data points does not work! in QlikView

Values on data points does not work!

Tue, 14 Jul 2015 08:25:13 GMT

Hi,

I am struggling with a Combo chart. Once in the beginning of the application (which I am not allowed to share, unfortunately), the Values on Data Points worked fine. This time however it will simply not show for both the lines and in the stacked bars. I made a total on the top of the stacked bars (using invisible trick), it does do not work anymore. I made some set analysis since, but I cannot see how that should effect it.

When I use the "Enable X-axis Scrollbar" and reduced the items to like 5, it actual works, but there should be place for the text even with 20 items.

Re: Values on data points does not work!

morganaaron — Tue, 14 Jul 2015 08:46:50 GMT

HI Mikael,

Can you share the expressions you're using to calculate the total values?

Re: Values on data points does not work!

Tue, 14 Jul 2015 09:12:09 GMT

Hmm not as they are, but to show the total for the stacked bars, I for a start use:

Round(Expression1+Expression2+Expression3)

And then this is marked:

When I then use this:

It shows the total, but if I set it to 20, it is gone, there should be place for it. I tried to change size in text format under the expression, but no luck so far.

Re: Values on data points does not work!

Tue, 14 Jul 2015 09:24:27 GMT

Even when I marked this one:

Again, it does shows vertical for 15 items, but not for 20.

Re: Values on data points does not work!

morganaaron — Tue, 14 Jul 2015 10:23:35 GMT

Bizarre - the values shouldn't disappear regardless of size, for me even with 30+ bars the values just get crumpled into one big mess even at the smallest width possible.

What version of Qlik are you using? And what dimension are you running the values over? Just wondering if there's something invalidating the expression somehow.

Re: Values on data points does not work!

Tue, 14 Jul 2015 10:33:07 GMT

Thx, I would have expected the same.

QV 11.20 SR12.

I do use a calculated dimension, but even if I choose a simpel dimension like YearMonth, it does not work.

Re: Values on data points does not work!

avinashelite — Tue, 14 Jul 2015 11:03:56 GMT

Hi Mikael,

As per knowledge , you should able to get the value on the data points, Can you please create a sample app with test data? so that we can see whats the issue

Re: Values on data points does not work!

morganaaron — Tue, 14 Jul 2015 12:40:25 GMT

Short of being able to see the issue myself, I can only suggest sending an email to Qlik support and seeing if this is a bug - I use SR10 and can't seem to replicate the issue, so that would be the next logical step!

Re: Values on data points does not work!

Tue, 14 Jul 2015 12:42:55 GMT

Hmm, If I do a new application with an inline table and simple dummy data, it works fine. As a matter of fact I dont even need the extra Total expression, if I mark Values on Data Points on each expression and stack them, it shows the total on top.

Re: Values on data points does not work!

stigchel — Tue, 14 Jul 2015 12:57:38 GMT

-Mikael- wrote:

Even when I marked this one:

Again, it does shows vertical for 15 items, but not for 20.

Try setting the value for max values shown to e.g. 1000 instead of 100

Re: Values on data points does not work!

Tue, 14 Jul 2015 13:25:36 GMT

Thx, it worked

I dont even have 100 datapoints, and I did try with 200. The breaking seems for whatever reason to be around 400.

Though I still need the total expression, but it works both hori. and vertical.