"Relative" Mini Chart

Thu, 25 Jun 2009 07:48:20 GMT

I would like to make a "Relative" Mini Chart / sparkline. For example I have a simple straight table with a relative expression that adds up to 100% (25% product A, 75% product B). I would like to add a mini chart to add insight into how this product split has changed over time. (not the grand totals)

For example May 70/30, June 75/25, July 80/20.

I have checked "relative" and created the chart however I do not believe this feature does anything. The chart doesn't change whether the box is checked or unchecked. Instead it just appears to show grand totals.

I realize a stacked bar chart could show the same however that would defeat the purpose of the "mini" 🙂

Thanks in advance.

"Relative" Mini Chart

Fri, 22 Oct 2010 08:38:40 GMT

Hello Keith,

I realize that this is an old post but I had the same problem. I solved it by using a TOTAL qualifier instead of using the relative checkbox.

My expression: sum({set} SalesAmount)

My time dimension: YearWeek

My relative expression for the Mini Chart: Sum ( {set} SalesAmount)/Sum( {set} TOTAL <YearWeek> SalesAmount).

I've excluded the set expression since it wasn't part of the problem.

Regards Henrik

topic "Relative" Mini Chart in QlikView

"Relative" Mini Chart

"Relative" Mini Chart