topic Re: Sparkline first and last value in QlikView

Sparkline first and last value

Fri, 20 May 2011 18:22:57 GMT

Hi,

does anyone know how to identify the first and last value in a sparkline? Obviously the object itself is written to enable the user to color it, but I'd like to put the first and last values represented as numbers adjacent to the sparkline on either side.

Here is my formula for my sparkline:

avg({1<L90Days={1}>} DataPoint)

In the sparkline the dimension I'm moving over is days.

Any help anyone can provide is greatly appreciated.

Cheers,

Jeff G

Re: Sparkline first and last value

Mon, 15 Aug 2011 19:37:53 GMT

The following structure will give you the "last" point within the sparkline.

Avg ( {$< filing_date={"=(max(filing_date))"} >} total_assets )

Sparkline first and last value

Tue, 04 Oct 2011 17:19:31 GMT

That makes sense for the max, but the min is tricky. Each row has a different start point for computation. If you use min on the filing_date, then you get the first filing_date, not the the first filing_date for that dimension value. Any thoughts?

Sparkline first and last value

Tue, 04 Oct 2011 17:48:30 GMT

Hi,

may you post an example qvw with your problem?

Stefano.

Re: Sparkline first and last value

Tue, 04 Oct 2011 19:42:53 GMT

I don't know if this is your problem, but look at my example ane the property "show value" of the expression.

C u,

Stefano.