topic Re: Maximum value over a dimension in QlikView

Maximum value over a dimension

richard_chilvers — Fri, 16 Nov 2012 16:14:54 GMT

Apologies if this question has been answered previously!

My data is as follows:

I would like a chart over dimension Code, selecting just the single value for each Code with the latest (MAX) date.

ie. A=13, B=27 and C=13 (ultimately, I will be summing all these values).

Advice please

Thanks

swuehl — Fri, 16 Nov 2012 16:17:49 GMT

Try

=FirstSortedValue(Value, -Date)

as expression (Date should be interpreted as Date with a numeric representation by QV already), using Code as dimension.

shree909 — Fri, 16 Nov 2012 16:25:14 GMT

if u think that maxvalue is always calculated only for latest date then u can write max(only{<date=${'maxdate'}>} value)

so create a maxdate variable

richard_chilvers — Fri, 16 Nov 2012 16:42:27 GMT

Thank you !

I have not used that function before

yashcena — Tue, 17 Jul 2018 12:15:32 GMT

Hi Stefan,

I have a similar requirement

This is how my chart looks like now:

I want the chart like this:

With Week also added as a dimension in the chart (along with resourcename), the firstsortvalue then sorts for each week. So I get the same thing:

Expression: FirstSortedValue([Remaining Hours],date#(Week))

But I get the same chart:

Is there any way to do what I'm looking for?

Thanks,

YASH

swuehl — Tue, 17 Jul 2018 20:06:50 GMT

Use Remaining Hours as second dimension and Min(Week) as expression.