How to filter one color and then select the maximum number of the other column

[wcamarg3]

Hi all,

I am trying to filter using 'WildMatch' by the column "Model Number", and then selecting the Maximum value from the column "Week", but I am not suceeding.

This is the formula I am using: =if(WildMatch(model_number,'*4*'),Max(Week,1))

Does anyone have any idea?

[MarcoWedel]

Can you describe the data you have and the result you expect based on this data?

[wcamarg3]

Hi Marco.

I have a table like this:

Model Number	Week
4DPJ	8
4KOL	8
4UJIO	9
5UJL	10

I would like to return me the value "9", because it is the highest value from a "Model Number" which contains the number 4.

[pooja_prabhu_n]

Hi,

You can try something like this

=if(WildMatch([Model Number],'*4*'),Max(ALL{<[Model Number]={"4*"}>} Week))

[Or · Accepted solution]

Assuming I read the requirement correctly, this shouldn't require Wildmatch, but rather a max with set analysis would be easiest:

Max({< [Model Number] = {"4*"} >}  Week)

Load * INLINE [
Model Number, Week
4DPJ, 8
4KOL, 8
4UJIO, 9
5UJL, 10];

[wcamarg3]

Thank you @pooja_prabhu_n . It is returning me a "-" instead of the desired value. Do you know what it could be?

Many thanks,

Wil

[wcamarg3]

Amazing! Thank you @Or ! Really helped me!

[pooja_prabhu_n]

Basically set analysis should work, If you are using it in text box then just use =Max({<[Model Number]={"4*"}>} Week).

Verify column names like week or Week.

Check if there are any errors in expression, If possible could you please provide more details.