topic Set Analysis or ? in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/262916#M98946 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>You can combine set analysis to do a OR in the set analysis clause. You can read the Help (search Set Analysis), some examples are provided.</P></BODY></HTML> Wed, 08 Feb 2012 12:40:59 GMT nstefaniuk 2012-02-08T12:40:59Z Set Analysis or ? https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/262914#M98944 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have aproblem and I hope you can help me ..</P><P></P><P>I am goingto make a report that shows ALL active orderlines plus orderlines ended in a specific(Selected)period.</P><P></P><P>The following fields are being used: ItemNo, Status, EndDate</P><P></P><P>Status canbe either Active or Ended. EndDate can be actual enddate OR if status = ActiveEndDate = Today</P><P></P><P>Does myquestion make any sence ?</P></BODY></HTML> Wed, 08 Feb 2012 12:15:22 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/262914#M98944 Anonymous 2012-02-08T12:15:22Z Set Analysis or ? https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/262915#M98945 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>please upload a short example *.qvw we can work with.</P><P></P><P>Thank you!</P><P></P><P>Rainer</P></BODY></HTML> Wed, 08 Feb 2012 12:22:30 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/262915#M98945 2012-02-08T12:22:30Z Set Analysis or ? https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/262916#M98946 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>You can combine set analysis to do a OR in the set analysis clause. You can read the Help (search Set Analysis), some examples are provided.</P></BODY></HTML> Wed, 08 Feb 2012 12:40:59 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/262916#M98946 nstefaniuk 2012-02-08T12:40:59Z Re: Set Analysis or ? https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/262917#M98947 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Here's an example.</P><P></P><P>What i would like is that if i select "jan" in month, item 1001 should appear since its still active. </P><P></P><P>So the result would be:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="68" style="border-image: initial; width: 460px; height: 63px; border-width: 1px; border-color: #000000; border-style: solid;" width="458"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Item</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Status</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>EndDate</STRONG></SPAN></TH></TR><TR><TD>1001</TD><TD>Active</TD><TD>08-02-2012</TD></TR><TR><TD>1003</TD><TD>Ended</TD><TD>31-01-2012</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 08 Feb 2012 12:47:32 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/262917#M98947 Anonymous 2012-02-08T12:47:32Z Re: Set Analysis or ? https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/262918#M98948 <HTML><HEAD></HEAD><BODY><P>Maybe you could use something like</P><P></P><P>=only({&lt;Status={Active},EndMonth=&gt;+&lt;EndMonth=EndMonth&gt;} EndDate)</P><P></P><P>as additional expression (which could be hidden in presentation tab) in a straight table, if you select in EndMonth as your relevant period.</P><P></P><P>See also attached.</P><P></P><P>Stefan</P></BODY></HTML> Wed, 08 Feb 2012 13:16:40 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/262918#M98948 swuehl 2012-02-08T13:16:40Z Set Analysis or ? https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/262919#M98949 <HTML><HEAD></HEAD><BODY><P>Just what i needed.</P><P></P><P>Thanks a lot!!</P></BODY></HTML> Wed, 08 Feb 2012 13:39:05 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-or/m-p/262919#M98949 Anonymous 2012-02-08T13:39:05Z