How to filter one column and apply a filter on other at QlikView

[wcamarg3]

Hi all,

I am trying to apply a filter in one column "model_number" and then the maximum number of the other filed, "Week".

This is the formula that I tried.

=if(WildMatch(model_number,'*4*'),Max(Week,1))

Does anyone can help me to formulate this?

[ASEDavidSu]

I'm not sure if this is what you want.