topic Re: Set analysis in QlikView https://community.qlik.com/t5/QlikView/Set-analysis/m-p/424117#M158038 <HTML><HEAD></HEAD><BODY><P>Requirement is same as mentioned, will it work or not correct please do let me know.</P></BODY></HTML> Wed, 17 Oct 2012 15:48:23 GMT 2012-10-17T15:48:23Z Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/424116#M158037 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P></P><P>May i know that below expression is ok?. Because I used set analysis expression for workhour and travelhour and simple if condition for ContractedTime.</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>)))</P><P></P><P>Can we use set analysis and if condition in one expression as above. Any suggestion appreciated.</P></BODY></HTML> Wed, 17 Oct 2012 15:45:36 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/424116#M158037 2012-10-17T15:45:36Z Re: Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/424117#M158038 <HTML><HEAD></HEAD><BODY><P>Requirement is same as mentioned, will it work or not correct please do let me know.</P></BODY></HTML> Wed, 17 Oct 2012 15:48:23 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/424117#M158038 2012-10-17T15:48:23Z