topic Union of two fields in same table in App Development https://community.qlik.com/t5/App-Development/Union-of-two-fields-in-same-table/m-p/1310950#M27977 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have 3 fields, Open Date , Close Date and Status.</P><TABLE border="1" class="jiveBorder" height="149" style="border: 1px solid #000000; width: 390px; height: 127px;" width="388"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Open Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Close Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Status</TH></TR><TR><TD style="padding: 2px;">1/15/2017</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Open</TD></TR><TR><TD style="padding: 2px;">2/20/2017</TD><TD style="padding: 2px;">2/20/2017</TD><TD style="padding: 2px;">Close</TD></TR><TR><TD style="padding: 2px;">2/22/2017</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Open</TD></TR><TR><TD style="padding: 2px;">3/25/2017</TD><TD style="padding: 2px;">3/26/2017</TD><TD style="padding: 2px;">Close</TD></TR><TR><TD style="padding: 2px;">3/26/2017</TD><TD style="padding: 2px;">4/11/2017</TD><TD style="padding: 2px;">Close</TD></TR></TBODY></TABLE><P></P><P>i want to show the month for union of (open date ,close date) fields in a list box using expressions.Please help me to achieve this.</P><P></P><P><STRONG>Desired Output:</STRONG></P><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid #000000; width: 90px; height: 113px;" width="88"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Month</TH></TR><TR><TD style="padding: 2px;"><P>Jan</P></TD></TR><TR><TD style="padding: 2px;">Feb</TD></TR><TR><TD style="padding: 2px;">Mar</TD></TR><TR><TD>Apr</TD></TR></TBODY></TABLE><P></P><P>So that, if i click on "Feb",it displays 1 Open ticket and 1 close ticket in chart.</P><P></P><P>thanks</P></BODY></HTML> Fri, 14 Jul 2017 10:48:32 GMT 2017-07-14T10:48:32Z Union of two fields in same table https://community.qlik.com/t5/App-Development/Union-of-two-fields-in-same-table/m-p/1310950#M27977 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have 3 fields, Open Date , Close Date and Status.</P><TABLE border="1" class="jiveBorder" height="149" style="border: 1px solid #000000; width: 390px; height: 127px;" width="388"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Open Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Close Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Status</TH></TR><TR><TD style="padding: 2px;">1/15/2017</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Open</TD></TR><TR><TD style="padding: 2px;">2/20/2017</TD><TD style="padding: 2px;">2/20/2017</TD><TD style="padding: 2px;">Close</TD></TR><TR><TD style="padding: 2px;">2/22/2017</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Open</TD></TR><TR><TD style="padding: 2px;">3/25/2017</TD><TD style="padding: 2px;">3/26/2017</TD><TD style="padding: 2px;">Close</TD></TR><TR><TD style="padding: 2px;">3/26/2017</TD><TD style="padding: 2px;">4/11/2017</TD><TD style="padding: 2px;">Close</TD></TR></TBODY></TABLE><P></P><P>i want to show the month for union of (open date ,close date) fields in a list box using expressions.Please help me to achieve this.</P><P></P><P><STRONG>Desired Output:</STRONG></P><TABLE border="1" class="jiveBorder" height="124" style="border: 1px solid #000000; width: 90px; height: 113px;" width="88"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Month</TH></TR><TR><TD style="padding: 2px;"><P>Jan</P></TD></TR><TR><TD style="padding: 2px;">Feb</TD></TR><TR><TD style="padding: 2px;">Mar</TD></TR><TR><TD>Apr</TD></TR></TBODY></TABLE><P></P><P>So that, if i click on "Feb",it displays 1 Open ticket and 1 close ticket in chart.</P><P></P><P>thanks</P></BODY></HTML> Fri, 14 Jul 2017 10:48:32 GMT https://community.qlik.com/t5/App-Development/Union-of-two-fields-in-same-table/m-p/1310950#M27977 2017-07-14T10:48:32Z Re: Union of two fields in same table https://community.qlik.com/t5/App-Development/Union-of-two-fields-in-same-table/m-p/1310951#M27978 <HTML><HEAD></HEAD><BODY><P>Look here on how to handle this situation:</P><P><A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A></P></BODY></HTML> Fri, 14 Jul 2017 11:48:00 GMT https://community.qlik.com/t5/App-Development/Union-of-two-fields-in-same-table/m-p/1310951#M27978 sunny_talwar 2017-07-14T11:48:00Z