Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Sparkline first and last value

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

Tags (1)
4 Replies
Not applicable

Re: Sparkline first and last value

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

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

Not applicable

Sparkline first and last value

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?

Not applicable

Sparkline first and last value

Hi,

may you post an example  qvw with your problem?

Stefano.

Not applicable

Re: Sparkline first and last value

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.

Community Browser