topic Re: Dimension Limits and Sparklines in QlikView

Dimension Limits and Sparklines

wonkymeister — Thu, 15 Dec 2016 11:12:39 GMT

Hello all.

is there a way to use dimension limits to create a sub total, without it subtotaling an expression that is displayed as a sparkline?

I want to sub total my straight table, but one of the expressions is a spark line chart that shouldn't be sub totaled.

with a sub total:

Without a sub total it displays perfectly:

is it possible to sub total all my expressions bar the sparkline?

thanks in advance!

lironbaram — Thu, 15 Dec 2016 11:20:40 GMT

try to warp your expression with Dimensionality function

for example :

if(Dimensionality()>1, sum([Sales]))

wonkymeister — Thu, 15 Dec 2016 11:22:30 GMT

brilliant! works a treat!

thanks a million!