Tableau Fixed function to QuickSight LAC

Question & Answer
,
1

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.

image
image722×71 23.9 KB

@Max @Biswajit_1993 @Sanjeeb2022

2

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

3 Likes
3

Thanks @Biswajit_1993 . It worked :slight_smile:

1 Like
4

Good to know @MadhuB you found out the solutions.

Thanks & Regards
Biswajit Dash

1 Like