topic maxstring with two possible values in QlikView

maxstring with two possible values

marcel_olmo — Thu, 28 Nov 2013 17:44:00 GMT

Hi guys! I'm using the maxstring() function to get the maximum read book of a list, and it works well.

The problem is that sometimes I got more than one possible row, and I have the maximum value in a textbox and the same metric in a straight table, and not always they are at the top position.

Do you know how to fix it? Here you have an image explaining what I'm saying.

Regards, Marcel.

Re: maxstring with two possible values

Jason_Michaelides — Thu, 28 Nov 2013 17:45:37 GMT

Instead of MaxString() have you tried Rank() or FirstSortedValue()?

Re: maxstring with two possible values

marcel_olmo — Thu, 28 Nov 2013 17:52:19 GMT

Yes, and it didn't work. In the forum the people recommended me using maxstring to get my goal.

The problem is that when I have two books with the same value, I found no way to put an "order by" clause.

Regards, Marcel.

Re: maxstring with two possible values

Jason_Michaelides — Thu, 28 Nov 2013 18:08:18 GMT

Can you post a sample app?

Re: maxstring with two possible values

Clever_Anjos — Thu, 28 Nov 2013 18:12:28 GMT

Try something like,

If two or more books share the same rank, the first one in alphabetical order will be returned

=FirstSortedValue(Book,-Aggr(Sum(Sales)+rank(Book,Book)/10,Book))

Re: maxstring with two possible values

tresB — Thu, 28 Nov 2013 18:15:40 GMT

May be like sample attached ?

Expression like: =MaxString(Aggr(If(Rank(Sum(Amt))=1,Str),Str))