topic Re: Combining 2 fields together in QlikView https://community.qlik.com/t5/QlikView/Combining-2-fields-together/m-p/737748#M263817 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> you can concatenate them:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Posting Year</SPAN>] &amp; [<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Posting Month</SPAN>] AS <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">newPosting</SPAN>.</P></BODY></HTML> Thu, 24 Jul 2014 07:37:09 GMT noman212 2014-07-24T07:37:09Z Combining 2 fields together https://community.qlik.com/t5/QlikView/Combining-2-fields-together/m-p/737744#M263813 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have 2 columns within the same table -</P><P></P><P>Posting Month</P><P>Posting Year</P><P></P><P>Some how i want to show them together, any way of doing this?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 24 Jul 2014 07:22:15 GMT https://community.qlik.com/t5/QlikView/Combining-2-fields-together/m-p/737744#M263813 2014-07-24T07:22:15Z Re: Combining 2 fields together https://community.qlik.com/t5/QlikView/Combining-2-fields-together/m-p/737745#M263814 <HTML><HEAD></HEAD><BODY><P>Load </P><P>...</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Posting Month</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Posting Year</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">...</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Posting Year &amp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Posting Month</SPAN> as newPosting</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">...</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">from</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">...</P></BODY></HTML> Thu, 24 Jul 2014 07:26:41 GMT https://community.qlik.com/t5/QlikView/Combining-2-fields-together/m-p/737745#M263814 alexandros17 2014-07-24T07:26:41Z Re: Combining 2 fields together https://community.qlik.com/t5/QlikView/Combining-2-fields-together/m-p/737746#M263815 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>.....</P><P>//Posting Month</P><P>//Posting Year</P><P>....</P><P>Posting Month &amp; '-' &amp; Posting Year as PostingYear</P><P>.................</P></BODY></HTML> Thu, 24 Jul 2014 07:32:16 GMT https://community.qlik.com/t5/QlikView/Combining-2-fields-together/m-p/737746#M263815 sibideepak 2014-07-24T07:32:16Z Re: Combining 2 fields together https://community.qlik.com/t5/QlikView/Combining-2-fields-together/m-p/737747#M263816 <HTML><HEAD></HEAD><BODY><P>thank you! Perfect</P></BODY></HTML> Thu, 24 Jul 2014 07:36:21 GMT https://community.qlik.com/t5/QlikView/Combining-2-fields-together/m-p/737747#M263816 2014-07-24T07:36:21Z Re: Combining 2 fields together https://community.qlik.com/t5/QlikView/Combining-2-fields-together/m-p/737748#M263817 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> you can concatenate them:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Posting Year</SPAN>] &amp; [<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Posting Month</SPAN>] AS <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">newPosting</SPAN>.</P></BODY></HTML> Thu, 24 Jul 2014 07:37:09 GMT https://community.qlik.com/t5/QlikView/Combining-2-fields-together/m-p/737748#M263817 noman212 2014-07-24T07:37:09Z