Tableau Fixed function to QuickSight LAC

Hi All,

we are migrating the reports from Tableau to QuickSight. I am trying to convert a tableau function similar to below

Tableau - If { Fixed [Level1],[Level2],[Level3],[Level4] : max([sequence]) } = [sequence] THEN TRUE ELSE FALSE END

QuickSight - ifelse (max({sequence}, [{Level1},{Level2},{Level3},{Level4}]) = {sequence}, “TRUE”, “FALSE”)

I am getting below error pointing to the ‘{sequence}’ field declared after ‘=’. If i replace that part with ‘1’ like below , it doesn’t show any error.

ifelse (max({sequence}, [{Level1},{Level2},{Level3},{Level4}]) = 1, “TRUE”, “FALSE”)

Please help on understanding this and how to get it working.

@Max @Biswajit_1993 @Sanjeeb2022

Hi @MadhuB,

Can you please change the some part of the formula for getting the required output.

  1. Instead of Max() function change it into MaxOver()
  2. On the If part instead of {sequence} changed it into Max({sequence})

Just do this two changes and revert back if it is working for you or not.

ifelse (maxOver(max({sequence}), [{Level1},{Level2},{Level3},{Level4}]) = max({sequence}), “TRUE”, “FALSE”)

Thanks & Regards
Biswajit Dash


Thanks @Biswajit_1993 . It worked :slight_smile:

1 Like

Good to know @MadhuB you found out the solutions.

Thanks & Regards
Biswajit Dash

1 Like