topic Re: Merging Data in QlikView https://community.qlik.com/t5/QlikView/Merging-Data/m-p/532016#M198749 <HTML><HEAD></HEAD><BODY><P>You need to give a space like below.</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Quarter &amp; " - " &amp; Month as </SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Quartr_Month</SPAN></P><P><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">thanks,</SPAN></P><P><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">-RV<BR /></SPAN></P></BODY></HTML> Mon, 26 Aug 2013 14:18:48 GMT rajeshvaswani77 2013-08-26T14:18:48Z Merging Data https://community.qlik.com/t5/QlikView/Merging-Data/m-p/532012#M198745 <HTML><HEAD></HEAD><BODY><P><BR />Hi all,</P><P>i have two fields below</P><P></P><P></P><P>Quarter&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month</P><P>Q1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan</P><P>Q2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Feb</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mar</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Apr</P><P></P><P>and i want to make new field like below</P><P></P><P>Quartr_Month</P><P>Q1 - Jan</P><P>Q1 - Feb</P><P>Q1 - Mar</P><P>Q1 - Apr</P><P>Q2 - Jan</P><P>Q2 - Feb</P><P>Q2 - Mar</P><P>Q2 - Apr</P><P></P><P>Can any one me on this,</P><P>Thanks in advance</P></BODY></HTML> Mon, 26 Aug 2013 14:09:37 GMT https://community.qlik.com/t5/QlikView/Merging-Data/m-p/532012#M198745 prasadreddy 2013-08-26T14:09:37Z Re: Merging Data https://community.qlik.com/t5/QlikView/Merging-Data/m-p/532013#M198746 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>this makes not much sense. What is the meaning of Quarter then?</P><P></P><P>- Ralf</P></BODY></HTML> Mon, 26 Aug 2013 14:11:44 GMT https://community.qlik.com/t5/QlikView/Merging-Data/m-p/532013#M198746 rbecher 2013-08-26T14:11:44Z Re: Merging Data https://community.qlik.com/t5/QlikView/Merging-Data/m-p/532014#M198747 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You could use &amp;</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Quarter &amp; "-" &amp; Month as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Quartr_Month</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">thanks,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Rajesh Vaswani<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Mon, 26 Aug 2013 14:14:38 GMT https://community.qlik.com/t5/QlikView/Merging-Data/m-p/532014#M198747 rajeshvaswani77 2013-08-26T14:14:38Z Re: Merging Data https://community.qlik.com/t5/QlikView/Merging-Data/m-p/532015#M198748 <HTML><HEAD></HEAD><BODY><P>Hi Rajesh,</P><P>But it is showing like below,</P><P></P><P>Quarter_Month</P><P>Q1-Jan</P><P>Q2-Feb</P><P>Q3-Mar</P></BODY></HTML> Mon, 26 Aug 2013 14:17:17 GMT https://community.qlik.com/t5/QlikView/Merging-Data/m-p/532015#M198748 prasadreddy 2013-08-26T14:17:17Z Re: Merging Data https://community.qlik.com/t5/QlikView/Merging-Data/m-p/532016#M198749 <HTML><HEAD></HEAD><BODY><P>You need to give a space like below.</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Quarter &amp; " - " &amp; Month as </SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Quartr_Month</SPAN></P><P><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">thanks,</SPAN></P><P><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">-RV<BR /></SPAN></P></BODY></HTML> Mon, 26 Aug 2013 14:18:48 GMT https://community.qlik.com/t5/QlikView/Merging-Data/m-p/532016#M198749 rajeshvaswani77 2013-08-26T14:18:48Z Re: Merging Data https://community.qlik.com/t5/QlikView/Merging-Data/m-p/532017#M198750 <HTML><HEAD></HEAD><BODY><P>Thnk you Rajesh,</P><P></P><P>It is working</P></BODY></HTML> Mon, 26 Aug 2013 14:21:01 GMT https://community.qlik.com/t5/QlikView/Merging-Data/m-p/532017#M198750 prasadreddy 2013-08-26T14:21:01Z