topic Sparkline dimension question in QlikView

Sparkline dimension question

Tue, 10 Apr 2012 17:07:23 GMT

Hi,

I’m attempting to create a sparkline within a straight table chart. My dimension is KPI Name. My expressions are Current Value, Target Value, Difference and the display options for these three expressions are set to Text. I want to add an additional expression that will display as a mini chart – sparkline which will show the trend of balances for the past 12 months from today’s date.

I was thinking that the best approach would be to create a dimension in the load script (Last12Mths) and then use that as the dimension for the mini chart. I have a field that was created called MonthEndDate that I could probably use.

Does this approach makes sense and if yes, can someone provide info on how I would create the dimension in my load script?

Thanks!

Sparkline dimension question

nilesh_gangurde — Tue, 10 Apr 2012 18:46:32 GMT

Hi slepore,

use the script mention below for the dimension field of mini chart.

date(monthstart(TempDate).'MMM-YYYY' ) as MonthYear

Regards,

Nilesh Gangurde

Sparkline dimension question

Tue, 10 Apr 2012 19:16:39 GMT

Hi,

This isn’t really getting me what I need. I am trying to create a dimension to be used in my mini chart that will be a rolling 12 months from today’s date. For example, I am looking to trend using a sparkline the values for April 2011 – to April 2012.

If this isn’t possible to do in the load script, is it possible to create a calculated dimension for a mini chart? It doesn’t appear to be possible which is why I was interested in trying to create this dimension in the load script.