Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
BIGuy
Contributor II
Contributor II

Need to show only those first cases which falls under criteria

Hello Qlik Gurus,

I am looking to get only those cases which scheduled Mon to Fri between 8:30 to 9 am and on Wednesday between 8:30 to 10 am. 
I need to exclude those "Red" highlighted once even though they are 1st cases but do not fall under "Mon to Fri between 8:30 to 9 am and on Wednesday between 8:30 to 10 am"
001.PNG

Expression which i have in 2nd screen shot :

002.PNG

 

Based on my expression i get 17 but in reality i need to get 13 rows.
"Delay" dimension is actually excluding those records which started less than 10 min ... i am trying to add some logic in this set analysis so i could just get those values which falls under "Mon to Fri between 8:30 to 9 am and on Wednesday between 8:30 to 10 am""


Script logic which i have for this Metric:

003.PNG

Thanks in Advance

Labels (2)
3 Replies
BIGuy
Contributor II
Contributor II
Author

Hello Gurus,

 

can any one help me on my topic please ? 

neelamsaroha157
Specialist II
Specialist II

Hi, Can you share some sample data in excel.

BIGuy
Contributor II
Contributor II
Author

Thanks for your reply. What other fields you would like to see in excel sheet ? I attached the sheet as well