Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahamed_Qlik
Specialist
Specialist

set analysis

Hi

I want to write below expression in set analysis :

 

" =COUNT(distinct {<S_ID={'686'},S_ACTION_LKCD={'APPROVE','SUBMIT'},USER_CATEGORY={'Other'},S_CODE={"*SRV-BMS*"},
C_KPI_ID={'126'},T_YEAR={'$(vTemp4)'},T_MONTH={'$(vTemp5)'}>}
if(NetWorkDays(Timestamp(aggr({<S_ID={'686'},T_YEAR={'$(vTemp4)'},T_MONTH={'$(vTemp5)'}>}Min(T_DATE),REQ_ID)),
Timestamp(aggr({<S_ID={'686'},T_YEAR={'$(vTemp4)'},T_MONTH={'$(vTemp5)'}>}MAX(MAX_ACTION_DATE),REQ_ID))) <=3,REQ_ID)) "


Labels (1)
0 Replies