topic Re: DATE Problem in QlikView https://community.qlik.com/t5/QlikView/DATE-Problem/m-p/589829#M1117123 <HTML><HEAD></HEAD><BODY><P>can u provide example qvw or data so we can understand clear<SPAN style="font-size: 10pt; line-height: 1.5em;">ly</SPAN></P></BODY></HTML> Sun, 16 Feb 2014 08:48:47 GMT 2014-02-16T08:48:47Z DATE Problem https://community.qlik.com/t5/QlikView/DATE-Problem/m-p/589827#M1117121 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>i have data in two tables,</P><P><STRONG style="text-decoration: underline;">Table1</STRONG></P><P><STRONG>Year</STRONG></P><P><STRONG>Month</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG style="text-decoration: underline;">Table2</STRONG></P><P><STRONG>Year</STRONG></P><P><STRONG>Month</STRONG></P><P><STRONG>Sales</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>But In Table1 having Years &amp; Table2 having Years are different years.</STRONG></P><P><STRONG>But i want Both information There is a Synthetic table firm in between them How i can Join this two.</STRONG></P><P><STRONG>to get both tables data.</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Please help me</STRONG></P></BODY></HTML> Sun, 16 Feb 2014 04:43:32 GMT https://community.qlik.com/t5/QlikView/DATE-Problem/m-p/589827#M1117121 2014-02-16T04:43:32Z Re: DATE Problem https://community.qlik.com/t5/QlikView/DATE-Problem/m-p/589828#M1117122 <HTML><HEAD></HEAD><BODY><P><STRONG style="text-decoration: underline;">Table1</STRONG></P><P><STRONG>Year</STRONG></P><P><STRONG>Month</STRONG></P><P><STRONG>'Table1'&nbsp; AS Selection<BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Concatenate<BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG style="text-decoration: underline;">Table2</STRONG></P><P><STRONG>Year</STRONG></P><P><STRONG>Month</STRONG></P><P><STRONG>Sales</STRONG></P><P><STRONG><STRONG>'Table2'&nbsp; AS Selection</STRONG></STRONG></P><P><STRONG><STRONG><BR /></STRONG></STRONG></P><P><STRONG><STRONG><BR /></STRONG></STRONG></P><P><STRONG><STRONG>You will get information from both the tables. Also synthetic table will not form in between them.</STRONG></STRONG></P><P><STRONG><STRONG>A new field will be created '<STRONG><STRONG>Selection', it will tell you the year and data is coming from which table.<BR /></STRONG></STRONG></STRONG></STRONG></P></BODY></HTML> Sun, 16 Feb 2014 08:38:40 GMT https://community.qlik.com/t5/QlikView/DATE-Problem/m-p/589828#M1117122 aveeeeeee7en 2014-02-16T08:38:40Z Re: DATE Problem https://community.qlik.com/t5/QlikView/DATE-Problem/m-p/589829#M1117123 <HTML><HEAD></HEAD><BODY><P>can u provide example qvw or data so we can understand clear<SPAN style="font-size: 10pt; line-height: 1.5em;">ly</SPAN></P></BODY></HTML> Sun, 16 Feb 2014 08:48:47 GMT https://community.qlik.com/t5/QlikView/DATE-Problem/m-p/589829#M1117123 2014-02-16T08:48:47Z