i am writing if condition for each Evaluation. like that i have multiple Evaluation sheets available so i need to do automation. like if i select Evaluation any value then directly display without writing if condition any other alternate.
You may replace the nested if-loops with a pick(match()) logic. But this is just a simplifying of the syntax and didn't change the approach itself.
I suggest that you do the essential work within the data-model and using an appropriate mapping for your first if-loop to group/categorize the data and for the second if-loop you should consider to transform the crosstable-structure into a stream-data-structure per: The Crosstable Load - Qlik Community - 1468083.
t2: load *, keepchar([Min/Max], 'Minax') as Type, purgechar([Min/Max], 'Minax') as Number, applymap('m', EvolutionField, 'no match') as XX resident t1;
Afterwards a simple max(Value) is enough to return the selection-related results. Should the selections be partly ignored/overwritten Type and Number could be used within a set analysis to modify the results.
The inline is just for demonstration purposes - nobody says you should use it. Nearly everything is better stored and loaded from a data-base or an Excel.
