topic Re: Sparkline not displaying in QlikView

Sparkline not displaying

Anonymous — Mon, 04 Aug 2014 09:49:01 GMT

I have a straight table chart with one dimension Account, and one expression Sum(sales).

I then want a sparkline mini chart to show the trend of sales over time. So I created a second expression of Sum(Sales) and set Display Options - Representation Format to Mini Chart. In the Mini Chart Settings I set Dimension = Sales Date.

I also have a Dimension Limit to Show Only First 20.

But some of the mini charts are blank.

Even stranger, if I click on one of the Accounts with the missing chart so the application is then filtered to just that account the mini chart then appears for that account. Account B in the screen shot, which previously had no mini chart displayed.

Whats going wrong with the mini charts?

Re: Sparkline not displaying

juleshartley — Mon, 04 Aug 2014 10:00:34 GMT

Is the date dimension roughly the same period for the different Accounts?

Re: Sparkline not displaying

juleshartley — Mon, 04 Aug 2014 10:01:04 GMT

ps. it might be helpful to have a sample app....

Re: Sparkline not displaying

senarath — Mon, 04 Aug 2014 10:05:52 GMT

Hi,

You could trouble shoot by converting the same into a Bar/Line chart and see whether working with period wise (as a dim)

thanx

Re: Sparkline not displaying

sujeetsingh — Mon, 04 Aug 2014 10:07:00 GMT

Cross check values and nulls

Re: Sparkline not displaying

Anonymous — Mon, 04 Aug 2014 10:19:33 GMT

I tried that, It's the same with all mini chart types. Some are just missing.

Re: Sparkline not displaying

Anonymous — Mon, 04 Aug 2014 10:22:57 GMT

I have heard of nulls causing problems before.

In the example above Account B. which was missing it's sparkline, has no nulls, it has sales for each day. And as we can see from the second screen shot, once Account B is filtered on, the sparkline magically appears.

Re: Sparkline not displaying

juleshartley — Mon, 04 Aug 2014 10:26:45 GMT

...and it displays fine on a normal line chart when the other accounts are included?

Re: Sparkline not displaying

kiranmanoharrode — Mon, 04 Aug 2014 10:32:13 GMT

Use AGGR in your Expression..

It will solve your issue

Re: Sparkline not displaying

Anonymous — Mon, 04 Aug 2014 10:39:41 GMT

My expression is =Sum(Sales) it is an aggregated expression rather than an atomic value like =Sales

How will using AGGR() change this? And what should I AGGR()?

Re: Sparkline not displaying

sudeepkm — Mon, 04 Aug 2014 10:45:32 GMT

create another chart exactly same as the first chart and see if you are seeing the same issue.

Or maybe create another QVW and create a new chart with mini chart option.

Re: Sparkline not displaying

Anonymous — Mon, 04 Aug 2014 10:45:58 GMT

I think it is being caused in some way by the Dimension Limit functionality.

If I remove the Dimension Limit and allow the table to show ALL accounts not just the top 20 then the sparkline is displayed for ALL the rows.

Note : the scroll bar on the right, chart no longer restricted to top 20 rows, There are now 1000s of accounts in there and the chart copes happily with rendering MANY mini charts. None are missing

I've often had problems with Dimension Limit. It seems very buggy.

Re: Sparkline not displaying

sudeepkm — Mon, 04 Aug 2014 10:52:21 GMT

You are right. Good finding.

I suspect this as a bug unless an explanation is found.

I'm able to reproduce this issue in my App by enabling the dimension limit.

Re: Sparkline not displaying

Anonymous — Thu, 30 Oct 2014 14:04:41 GMT

I should have read the release notes!!

Page 8 states:

"Dimension limits should not be used in tables that contain mini-charts"

So I'm trying to do something that is not advised (basically it's a bug but they won't admit it/spend time fixing it )