Qlikview

[Sureshbabukapu]

Load *, 

         '2nd Purchase level' as Service

        , Case_id as Case_id3

Resident dim_purchase

where purchase_level='second purchase level' and not wild match (case_register_status, 'not enrollment') ;

I tried something but it's not went well if you have any views on this guide me 

My Requirement:how to exclude 2nd purchase level with a case register status of 'not enrollment'

[anat]

Load *, 

         '2nd Purchase level' as Service

        , Case_id as Case_id3

Resident dim_purchase

where purchase_level='second purchase level' and not wild match (case_register_status, '*not enrollment*') ;