topic Merging 2 columns into a dimension in QlikView https://community.qlik.com/t5/QlikView/Merging-2-columns-into-a-dimension/m-p/590971#M1122637 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have table that provides an open and a close tickets for a given ticket, and I need to chart it such that I get the # of tickets opened and closed per day. see attached for a quick example.</P><P></P><P>Can do it with pivoting the table such that it has a TicketId, OpenClose Flag &amp; Date as columns, but am looking for a smarter way so that I don't need to create an intermediate tables.</P><P></P><P>Any help would be appreciated.</P></BODY></HTML> Thu, 30 Jan 2014 19:55:32 GMT 2014-01-30T19:55:32Z Merging 2 columns into a dimension https://community.qlik.com/t5/QlikView/Merging-2-columns-into-a-dimension/m-p/590971#M1122637 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have table that provides an open and a close tickets for a given ticket, and I need to chart it such that I get the # of tickets opened and closed per day. see attached for a quick example.</P><P></P><P>Can do it with pivoting the table such that it has a TicketId, OpenClose Flag &amp; Date as columns, but am looking for a smarter way so that I don't need to create an intermediate tables.</P><P></P><P>Any help would be appreciated.</P></BODY></HTML> Thu, 30 Jan 2014 19:55:32 GMT https://community.qlik.com/t5/QlikView/Merging-2-columns-into-a-dimension/m-p/590971#M1122637 2014-01-30T19:55:32Z