Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Unable to find the Maximum value in a string

I have data similar like this.

ParentChildAmount
AA.110
AA.212
AA.313
AA.414
AA.1115
AA.1316
AA.3217
AA.3318
BB.12
BB.23
BB.34
BB.215

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,

SP

1 Solution

Accepted Solutions
Highlighted

May be this

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

View solution in original post

6 Replies
Highlighted

What object are you using here?

Highlighted
Contributor III
Contributor III

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

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

Highlighted
Contributor III
Contributor III

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.

Highlighted

May be this

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

View solution in original post

Highlighted
Contributor III
Contributor III

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