Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Help with Date



I have a KPI that looks at appointments kept bases on wether the attendance time falls within two field times APPT_WINDOW_START and APPOINT_WINDOW_END. Is the attendance falls outside of these two dates its classed as a fail.


However what i want to do is allow the attendance to be before the APPT_WINDOW_START and allow this as a pass.


The KPI in the script is calculated as follows:-



SET vExp_MUIR_NEW_KPI_Pass_005 = "Num(COUNT({$< $(vExp_CanonicalFlag_APPT_WIN_START), $(vExp_WC_MUIR_NEW_GEN), $(vExp_Job_Status_Not_6), $(vExp_ApptKeptQualify_P), $(vExp_ApptKeptClient_P) >}[SK_APPTOPTIKEY]),'#0')";



SET vExp_MUIR_NEW_KPI_Fail_005 = "Num(COUNT({$< $(vExp_CanonicalFlag_APPT_WIN_START), $(vExp_WC_MUIR_NEW_GEN), $(vExp_Job_Status_Not_6), $(vExp_ApptKeptQualify_P), $(vExp_ApptKeptClient_F) >}[SK_APPTOPTIKEY]),'#0')";


The set analysis for (vExp_CanonicalFlag_APPT_WIN_START) is  = [%%CANONICAL_FLAG]={'APPT'};


Does anyone have any ideas on how i can allow this specific KPI to allow attendances prior to the start date to go as a PASS. Is this just a case of removing the (vExp_CanonicalFlag_APPT_WIN_START) from the KPI itself?




0 Replies