Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-10-17 02:50 PM

multiple condition in set analysis

Hi,

How do i write below expression fullyin set analysis method as i have done partiallp.. please help.

(Sum({< Audit_Date = {"<=$(#vDateTo)>=$(#vDateFrom)"}> } WorkHour)+Sum({< Audit_Date = {"<=$(#vDateTo)>=$(#vDateFrom)"}> } TravelHour))

/

(sum( if(Start_Time_Date >=Date_Master_From and Finish_Time_Date<=Date_Master_To,Contracted_Time))-sum(  if(Scheduled_StartTime_Date>=Date_Master_From and Scheduled_FinishTime_Date<=Date_Master_To,SickHoliday_Time)))

337 Views
0 Likes
0 Replies