Expression - Statistica Enterprise Manager

[Ketki Deshkar]

I am trying to define an expression in the Subset node of my Workspace to pick the case based on the value available for variable (Parameter) named Parameter1 located in column V1. C1, C2 are my cases for Paramater1 variable.

This is what I am trying

Parameter = "Parameter1" AND max(C1.V1, C2.V1)

Unfortunately Max function has a limitation - it can only hold 2 values for comparison. I have multiple cases to choose the max value from for Parameter1.But I am giving MAX funtion a try. The above expression is not yielding any error but also not returning any result.

I need some guidance on the functions to use in order to write the expressions. Thank you.

[Sören Schönfeld]

Hi, without exact input/output spreadsheet, not sure what exact output you expect.

In case, you want some row filtering with the max value of a certain column you could try the VARMAX expression. Within a subset node, this expression should work:

Parameter1=VARMAX(Parameter1)