Can anyone give me correct syntax for the below code I am new to Quicksight

ifelse(

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.985 AND {BUSINESS SEGMENT} = "RLUS" AND {QM Count} = 1, 1,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.955 AND {BUSINESS SEGMENT} = "RLUS" AND {QM Count} = 1, 1,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.93 AND {BUSINESS SEGMENT} = "RLUS" AND {QM Count} = 1, 1,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.851 AND {BUSINESS SEGMENT} = "RLUS" AND {QM Count} = 1, 0,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0 AND {BUSINESS SEGMENT} = "RLUS" AND {QM Count} = 1, 0,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.985 AND {BUSINESS SEGMENT} = "FNWL" AND {QM Count} = 1, 1,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.955 AND {BUSINESS SEGMENT} = "FNWL" AND {QM Count} = 1, 1,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.93 AND {BUSINESS SEGMENT} = "FNWL" AND {QM Count} = 1, 1,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.851 AND {BUSINESS SEGMENT} = "FNWL" AND {QM Count} = 1, 0,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0 AND {BUSINESS SEGMENT} = "FNWL" AND {QM Count} = 1, 0,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0.95 AND {BUSINESS SEGMENT} = "Genpact" AND {QM Count} = 1, 1,

{ACTION REQUIRED} = 1 AND {ITEM SCORE} >= 0 AND {BUSINESS SEGMENT} = "Genpact" AND {QM Count} = 1, 0,

"No Action Required"

)

Hi @Samiksha,

Your statement logically looks right. I think the problem is in the result. You are returning 1 or 0 for valid cases (numeric) and “No Action Required” in the end which is string and hence may be getting an error.

Try putting the 1 and 0 in quotes and things should work fine.

2 Likes

Here if I am giving QM count = 1 then 1 somewhere it is 0 also that condition If I am giving is correct , I mean to ask syntactically is it correct ??

instead of no action required I can give “” ??

Hi @Samiksha - Do you have any sample data?

Regards,
Sanjeeb

Hi @Samiksha

You can use NULL if you want. This worked for me

No its client side data I cant share it here

Okay thanks Prabhu .

No issues @Samiksha . If your problem resolved, well and good. Or else you can share some mock data so that we can replicate and guide you.

Regards - Sanjeeb

Yes for now my problem is solved thank you so much .

Marking @Giridhar.Prabhu 's response as solution.

Regards,
Arun Santhosh
Pr QuickSight SA

1 Like