Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Help with Date

Hi,

 

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