topic Re: Exclude a dimension field in QlikView

Exclude a dimension field

qlikcheepirishe — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 06 Oct 2017 11:06:37 GMT

Try like:

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

if(KPI like 'Planned', PARTICULARS))

its_anandrjs — Thu, 12 Oct 2017 06:03:30 GMT

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.