topic Re: A union in chart's expression. Possible? in QlikView https://community.qlik.com/t5/QlikView/A-union-in-chart-s-expression-Possible/m-p/654152#M475966 <HTML><HEAD></HEAD><BODY><P>Perhaps if you post your expressions we can see what you're trying to do and help find an answer. Posting an example document that demonstrates the problem would be even better.</P></BODY></HTML> Wed, 25 Jun 2014 14:34:33 GMT Gysbert_Wassenaar 2014-06-25T14:34:33Z A union in chart's expression. Possible? https://community.qlik.com/t5/QlikView/A-union-in-chart-s-expression-Possible/m-p/654151#M475965 <HTML><HEAD></HEAD><BODY><P>I have 2 tables: 1st with companies (CID, manager, type) of 2 types distributed between managers and 2nd table with insurance contracts (InsID, CID, BegDate, EndDate) of 2 types. A type 1 company must have a valid type 1 contract. A type 2 company must have both type 1 and 2 valid contracts. I need to calculate the number of companies for each manager, that violate the rule on a given date (i.e IDs of companies that don't have active type 1 contract and IDs of type 2 companies that don't have active type 2 contract). But I needn't count a company twice if it is of type 2 and have neither type 1 contract nor type 2. In any other db I would make 2 separate queries, UNION them and then COUNT DISTINCT the result GROUP BY manager. But here... I've already made a separate expression for each query, but I need to join them. Can I make a union in expression? Maybe I can unite 2 set analysis operations in a single expression? Thanks in advance!</P></BODY></HTML> Wed, 25 Jun 2014 14:25:39 GMT https://community.qlik.com/t5/QlikView/A-union-in-chart-s-expression-Possible/m-p/654151#M475965 2014-06-25T14:25:39Z Re: A union in chart's expression. Possible? https://community.qlik.com/t5/QlikView/A-union-in-chart-s-expression-Possible/m-p/654152#M475966 <HTML><HEAD></HEAD><BODY><P>Perhaps if you post your expressions we can see what you're trying to do and help find an answer. Posting an example document that demonstrates the problem would be even better.</P></BODY></HTML> Wed, 25 Jun 2014 14:34:33 GMT https://community.qlik.com/t5/QlikView/A-union-in-chart-s-expression-Possible/m-p/654152#M475966 Gysbert_Wassenaar 2014-06-25T14:34:33Z Re: A union in chart's expression. Possible? https://community.qlik.com/t5/QlikView/A-union-in-chart-s-expression-Possible/m-p/654153#M475967 <HTML><HEAD></HEAD><BODY><P>You can check Set Operators Union. Two set of selections can be union operated.</P></BODY></HTML> Wed, 25 Jun 2014 14:43:35 GMT https://community.qlik.com/t5/QlikView/A-union-in-chart-s-expression-Possible/m-p/654153#M475967 sudeepkm 2014-06-25T14:43:35Z Re: Re: A union in chart's expression. Possible? https://community.qlik.com/t5/QlikView/A-union-in-chart-s-expression-Possible/m-p/654154#M475968 <HTML><HEAD></HEAD><BODY><P>Sure. That's the example of what I have for now...</P></BODY></HTML> Wed, 25 Jun 2014 21:05:51 GMT https://community.qlik.com/t5/QlikView/A-union-in-chart-s-expression-Possible/m-p/654154#M475968 2014-06-25T21:05:51Z Re: Re: A union in chart's expression. Possible? https://community.qlik.com/t5/QlikView/A-union-in-chart-s-expression-Possible/m-p/654155#M475969 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Thanks, I seem to figured out, how to apply it to my solution. Previously I had errors with setting brackets...</SPAN></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_14037648893199223" jivemacro_uid="_14037648893199223"> <P>Count({($&lt;Type={2}&gt;-&lt;BegDate={"&lt;=$(TargetDate)"},EndDate={"&gt;=$(TargetDate)"},Itype={2}&gt;)+($-&lt;BegDate={"&lt;=$(TargetDate)"},EndDate={"&gt;=$(TargetDate)"},Itype={1}&gt;)}Distinct CID)</P> </PRE></BODY></HTML> Thu, 26 Jun 2014 06:43:08 GMT https://community.qlik.com/t5/QlikView/A-union-in-chart-s-expression-Possible/m-p/654155#M475969 2014-06-26T06:43:08Z