topic Re: Unable to find the Maximum value in a string in QlikView

Unable to find the Maximum value in a string

Anonymous — Thu, 12 Apr 2018 14:39:51 GMT

I have data similar like this.

My requirement states that I have to show only these rows when a button is clicked. How can i achieve this.

I have tried MaxString, Aggr functions but dint help. Please advice.

Thanks,

sunny_talwar — Thu, 12 Apr 2018 14:42:28 GMT

What object are you using here?

Anonymous — Thu, 12 Apr 2018 14:44:35 GMT

Pivot Table, and there are couple of Expressions associated with the output of max value.

sunny_talwar — Thu, 12 Apr 2018 14:49:15 GMT

Is Child one of the dimension? If it is.. then may be like this

If(vVar = 1, Child, Aggr(If(Child = MaxString(TOTAL <Parent> Child), Child), Child, Parent))

Here vVar is based off of the button and make sure to check 'Suppress When Value is Null' on the dimensions tab of the chart properties

Anonymous — Thu, 12 Apr 2018 14:52:32 GMT

I tried already this earlier but the problem with this expression is the Output will give A.4, because logically A.4 is greater than A.33.

sunny_talwar — Thu, 12 Apr 2018 14:59:13 GMT

May be this

=If(vVar = 1, Child, Aggr(If(SubField(Child, '.', 2) = Max(TOTAL <Parent> SubField(Child, '.', 2)), Child), Child, Parent))

Anonymous — Thu, 12 Apr 2018 15:03:16 GMT

I think this should work. Let me test and get back to you!! Thanks