topic Re: Set Analysis Help for Sparkline in QlikView

Set Analysis Help for Sparkline

Mon, 24 Nov 2014 16:04:05 GMT

Greetings,

For one of the projects I'm currently working on I'm trying to show the yearly trend of production.

My formula for the sparkline is: =only({$<Week={"<=52"}, Group={'Structural'}>}[Raw Production ])

The expression definition box says the expression is ok, but nothing populates the desired cell.

Any help with correcting the formula would be greatly appreciated!

-Nick

Re: Set Analysis Help for Sparkline

JonnyPoole — Mon, 24 Nov 2014 16:13:08 GMT

the only() function is intended to render a value if there is only 1 value to render. If there are 2 for that data point it will render null() which seems like a possibility.

what happens if you sum() the values instead ?

also what is date or time based dimension being used for spark line ?

Re: Set Analysis Help for Sparkline

Mon, 24 Nov 2014 16:19:46 GMT

Jonathan,

The sum() function worked... I could have sworn that it didn't the morning, but that was before my first cup of coffee.

Thanks for the quick reply!

-Nick