Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Line Chart - Show Only MAX and MIN values

Hello!

I have the following line chart:

No Title.png

With the expression:

COUNT ({$<ID_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} DISTINCT TD_ENTRY_ID)

But I'd only like to show the MAX and MIN values from the chart.

Example: MAX = 6.961 and MIN = 1.226 (Show only those values and not the rest - 6295 and 6349)

Is that possible?

Thank you!!!

3 Replies
whiteline
Master II
Master II

Hi.

You can use rank function to check if the value is max or min.

swuehl
MVP
MVP

Maybe like attached.

Use the expression attribute 'Show value' instead of ticking the option 'Values on data points' under display options.

microwin88x
Creator III
Creator III
Author

Thank you! I've tried it and it works... The only thing is the following: I applied the Rank function as you said and sometimes it works, like this:

Sin título 2.png

And sometimes it only shows me the max value and I can't see the min value:

Sin título 1.png

But I always see the max. The problem is that sometimes it doesn't shows the min...

Why could that be?

--

Edit: Don't worry. I've tested it and it works for what I need. Thanks.