topic Re: Line Chart - Show Only MAX and MIN values in QlikView

Line Chart - Show Only MAX and MIN values

microwin88x — Tue, 25 Mar 2014 20:07:26 GMT

Hello!

I have the following line chart:

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!!!

whiteline — Tue, 25 Mar 2014 20:42:58 GMT

Hi.

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

swuehl — Tue, 25 Mar 2014 21:19:05 GMT

Maybe like attached.

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

microwin88x — Tue, 25 Mar 2014 23:19:35 GMT

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:

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

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.