Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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

4 Replies
Not applicable
Author

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

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

Not applicable
Author

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
Author

Hi,

may you post an example  qvw with your problem?

Stefano.

Not applicable
Author

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.