I am not getting the dimension having the categories

I am getting first 2 attributes, but franchise_operation i am getting . Can any one help please ?
ifelse(

  idgrp ='FRA','Loca', 
   idgrp ='CAFRA' OR idgrp ='INT','Locations_Int',
   idgrp ='FRA' OR idgrp ='CAFRA', OR idgrp = 'INT', 'franchise_operation', NULL)

@sasikanth,
Conditions are evaluated from top to bottom fashion, so since first two conditions are always true in your example scenario, third condition is not evaluated.If you change one of the values in third condition to be different from the first two conditions and the first two conditions fail then the third condition will be evaluated.

Let me know what you are trying to achieve by making third condition to include criteria that will be true for previous two conditions.

Thanks
Deepak

Hi, @sasikanth. Did @DeepakS solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!

1 Like