Exclude a dimension field

[qlikcheepirishe]

I have a field KPI in that I have Actual and planned and

other field name is PARTICULARS I just want to exclude Qlik filed from PARTICULARS

i.e. KPI--> Actual--> PARTICULARS--> 'Qlik'

Chart condition :

=if(KPI LIKE 'Actual'

and

PARTICULARS<> 'Qlik',(PARTICULARS),PARTICULARS)

However It is excluding both in Actual as well as in planned

[tresB]

Try like:

=if(KPI LIKE 'Actual' and PARTICULARS<> 'Qlik',PARTICULARS,

          if(KPI like 'Planned', PARTICULARS))

[its_anandrjs]

This way also

=if( Match(KPI,'Actual') and NOT Match(PARTICULARS,'Qlik') ,PARTICULARS,

  if( Match(KPI,'Planned'), PARTICULARS ) )

Or share the output for this with sample.