Hai all, My self Aravind, I am a student and iam new to qlikview. My requirement:
If a termination case is closed the same day as first level ,second level, third level then exclude the functional level fee
Load *,
'Functional level fee' as service,
Registration no as Registration_id3
Resident Rigister_case
Where Match(Rigister_year ,'one','two','three') and exists(dim_Rigister_key) and (Registration_status='rejected' and upper(Registration_status)='not received') and ((case_Register_date = case_Register_date_closed) and Match(Register_level ,'first level ','second level', 'third level') and not ('Functional level fee'));
While I run the script Functional level fee is missing from dashboard