topic multiple condition in set analysis in QlikView https://community.qlik.com/t5/QlikView/multiple-condition-in-set-analysis/m-p/425009#M158316 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How do i write below expression fullyin set analysis method as i have done partiallp.. please help.</P><P></P><P>(Sum({&lt; Audit_Date = {"&lt;=$(#vDateTo)&gt;=$(#vDateFrom)"}&gt; } <STRONG>WorkHour</STRONG>)+Sum({&lt; Audit_Date = {"&lt;=$(#vDateTo)&gt;=$(#vDateFrom)"}&gt; } <STRONG>TravelHour</STRONG>))</P><P>/</P><P>(sum( if(Start_Time_Date &gt;=Date_Master_From and Finish_Time_Date&lt;=Date_Master_To,<STRONG>Contracted_Time</STRONG>))-sum(&nbsp; if(Scheduled_StartTime_Date&gt;=Date_Master_From and Scheduled_FinishTime_Date&lt;=Date_Master_To,<STRONG>SickHoliday_Time</STRONG>)))</P></BODY></HTML> Wed, 17 Oct 2012 18:50:13 GMT 2012-10-17T18:50:13Z multiple condition in set analysis https://community.qlik.com/t5/QlikView/multiple-condition-in-set-analysis/m-p/425009#M158316 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How do i write below expression fullyin set analysis method as i have done partiallp.. please help.</P><P></P><P>(Sum({&lt; Audit_Date = {"&lt;=$(#vDateTo)&gt;=$(#vDateFrom)"}&gt; } <STRONG>WorkHour</STRONG>)+Sum({&lt; Audit_Date = {"&lt;=$(#vDateTo)&gt;=$(#vDateFrom)"}&gt; } <STRONG>TravelHour</STRONG>))</P><P>/</P><P>(sum( if(Start_Time_Date &gt;=Date_Master_From and Finish_Time_Date&lt;=Date_Master_To,<STRONG>Contracted_Time</STRONG>))-sum(&nbsp; if(Scheduled_StartTime_Date&gt;=Date_Master_From and Scheduled_FinishTime_Date&lt;=Date_Master_To,<STRONG>SickHoliday_Time</STRONG>)))</P></BODY></HTML> Wed, 17 Oct 2012 18:50:13 GMT https://community.qlik.com/t5/QlikView/multiple-condition-in-set-analysis/m-p/425009#M158316 2012-10-17T18:50:13Z