Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
=if(KPI LIKE 'Actual' and PARTICULARS<> 'Qlik',PARTICULARS,
if(KPI like 'Planned', PARTICULARS))
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.