topic Re: Determine Table Column Max Value? in QlikView

Determine Table Column Max Value?

richardouellett — Thu, 20 Aug 2015 22:13:24 GMT

The following formula (Dur) gives me the summary “Duration” column average total 35.03 in the table below. I am trying to create a formula to obtain the maximum value in the Duration column; in this case the value would be 171.87. Can you help me?

=$(=avg((i1_7))

Re: Determine Table Column Max Value?

sunny_talwar — Fri, 21 Aug 2015 03:24:40 GMT

May be this:

Max(Aggr(YourExpressionofDuration, YourChartDimensions))

Re: Determine Table Column Max Value?

richardouellett — Fri, 21 Aug 2015 03:25:10 GMT

That did not work as instructed; do you have more information/explanation?

Re: Determine Table Column Max Value?

sunny_talwar — Fri, 21 Aug 2015 03:31:24 GMT

What is your expression for Column Dur?

Re: Determine Table Column Max Value?

richardouellett — Fri, 21 Aug 2015 03:39:53 GMT

Sunny, below is the result of your formula. I have highlighted Dur in yellow.

Re: Determine Table Column Max Value?

sunny_talwar — Fri, 21 Aug 2015 03:42:05 GMT

Try this:

Max(TOTAL Aggr(YourExpressionofDuration, YourChartDimensions))

Max(TOTAL Aggr(Avg(i1_7))*1, Sequence))