Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

m_lavova
New Contributor

Reference line expression accoding filters

Hello everyone,

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

1 Reply
Community Manager
Community Manager

Re: Reference line expression accoding filters

Hi, is this for QlikView or Sense? I'd like to move it to the correct product forum. Thanks
Sue Macaluso