Hi,

I’m trying to implement “Max” function, as it works in excel - the function gets values and output the max between them. but in QS I can see only max on column. I just want it to do it:

max(1,2,3) > 3,

Thanks in advance,

noy

Hi @Noys

would do you want to achieve?

Do you have a sample or sample data?

E.g.

Dim1 / Dim2 / Dim3 / Value

There you can do a max(value) and will get the max out of all rows.

BR

Hi,

Thanks for your response.

I mean, I don’t want the max will be about one value, I want to find simple as it is - the max between the input values.

As I mentioned - I want to write max(1,2,3) and the output will be 3.

Thank you,

Noy

Yes, but the value in my case represents n values for each row of your dataset.

How will you get your values in to the max? Are you planning to hardcode it?

So the values are also column in my database

it’s means I wish to do MAX(column1, column2) so it will give the max between them

What about `ifelse(max(column1)>max(column2),max(column1),max(column2))`

I did something really similar,.

The difference between our solutions is that I compare the columns, regardless the max of each of them. So I did something like ifelse(column1>column2, column1, column2).

It’s looks nice solution and easy but actually when it’s about a lot of variables, and I want to compare between max on differences or something more complicated, the formula becomes very cumbersome, while it’s really easy in excel.

I attach a screen shot to you understand:

Comparing this quite short formula in excel:

Thanks again!

Noy

Hi @Noys

what type of datasource are you using?

Maybe you can do something on database level?

BR

Hello @ErikG ,

Yes. I can use another ways to implement my requirements. I just looked for a way in QuickSight

Thanks again!

Noy

Hi @Noys

did you found a solution?

BR