Discussion board where members can get started with Qlik Sense.
would you be so kind and help me, please?
In one application I have graph, where the Reference line is set by using expression. This Reference line depends on two filters: "Region" and "Business Segment".
"Region" includes : EUROPE-WEST, EUROPE-EAST, APAC-MEA, USC, LATIN AMERICA"Business Segment" includes: 8 diferent segments
For all data in filters are set different targets wrote as inline tables in Data loading editor.
My script works well but not completelly acording my requirement: when I select "Region"EUROPE-WEST abd EUROPE-EAST together the reference line of target has to correspond to EUROPE-EAST target.
I wanted to implement expression with "and", on the base which the cobination of "Regions" will included (highlighted in red), but it does not work:
=If(IsNull([Business Segment (M)]), if(IsNull(Region),Target, If(Region='EUROPE-WEST',TargetEUROPEWEST, If(Region='EUROPE-EAST',TargetEUROPEEAST,If(Region='EUROPE-EAST' and Region='EUROPE-WEST',TargetEUROPEEAST, If(Region='APAC-MEA',TargetAPACMEA, If(Region='USC',TargetUSC, If(Region='LATIN AMERICA',TargetLATINAMERICA)))))), if(IsNull(Region),STarget, If(Region='EUROPE-WEST',STargetEUROPEWEST, If(Region='EUROPE-EAST',STargetEUROPEEAST,If(Region='EUROPE-EAST' and Region='EUROPE-WEST',TargetEUROPEEAST, If(Region='APAC-MEA',STargetAPACMEA, If(Region='USC',STargetUSC, If(Region='LATIN AMERICA',STargetLATINAMERICA)))))))
Can you help me with right condition under which I can see EUROPE-EAST target, when I select regions 'EUROPE-EAST' and 'EUROPE-WEST'?
Thank you in advance for your help.B.R.,Monika