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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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)))

0 Replies