topic Problems Joining QVDs in QlikView https://community.qlik.com/t5/QlikView/Problems-Joining-QVDs/m-p/1050777#M940744 <HTML><HEAD></HEAD><BODY><P>Hello;</P><P>I am havig problems concatenating and joining QVDs becasue of dates.</P><P>I have two (or more) QVDs, all of them have dates and its years and months:</P><P>It is possble to have problmes joining or cancatenating them acording to their keys?</P><P></P><P><STRONG>QVD1</STRONG>:</P><P>load qvd1month</P><P>from QVDA;</P><P></P><P></P><P><STRONG>QVD2:</STRONG></P><P>load Month(qvd1month) as m_qvd1month</P><P>from QVDA;</P><P></P><P></P><P><STRONG>QVD3</STRONG>:</P><P>load Num(qvd1month) as n_qvd1month</P><P>from QVDA;</P><P></P><P></P><P>QDV1 Result:</P><P>qvd1month</P><P>jan</P><P>feb</P><P>mar</P><P>apr</P><P>may</P><P>jun</P><P>jul</P><P>ago</P><P>sep</P><P>oct</P><P>nov</P><P>dec</P><P></P><P></P><P>QDV2 Result:</P><P>m_qvd1month</P><P>jan</P><P>feb</P><P>mar</P><P>apr</P><P>may</P><P>jun</P><P>jul</P><P>ago</P><P>sep</P><P>oct</P><P>nov</P><P>dec</P><P></P><P></P><P>QDV3 Result:</P><P>n_qvd1month</P><P>1</P><P>7</P><P>12</P><P></P><P>QVD3 should return values from 1 to 12, but it return only 1,7 and 12. I want to preserve the month name but the join is not correct because of the problem I just described.</P><P>Please any help.</P><P></P><P>Tank you in advance.</P><P>Diego.</P></BODY></HTML> Thu, 21 Jan 2016 21:46:01 GMT 2016-01-21T21:46:01Z Problems Joining QVDs https://community.qlik.com/t5/QlikView/Problems-Joining-QVDs/m-p/1050777#M940744 <HTML><HEAD></HEAD><BODY><P>Hello;</P><P>I am havig problems concatenating and joining QVDs becasue of dates.</P><P>I have two (or more) QVDs, all of them have dates and its years and months:</P><P>It is possble to have problmes joining or cancatenating them acording to their keys?</P><P></P><P><STRONG>QVD1</STRONG>:</P><P>load qvd1month</P><P>from QVDA;</P><P></P><P></P><P><STRONG>QVD2:</STRONG></P><P>load Month(qvd1month) as m_qvd1month</P><P>from QVDA;</P><P></P><P></P><P><STRONG>QVD3</STRONG>:</P><P>load Num(qvd1month) as n_qvd1month</P><P>from QVDA;</P><P></P><P></P><P>QDV1 Result:</P><P>qvd1month</P><P>jan</P><P>feb</P><P>mar</P><P>apr</P><P>may</P><P>jun</P><P>jul</P><P>ago</P><P>sep</P><P>oct</P><P>nov</P><P>dec</P><P></P><P></P><P>QDV2 Result:</P><P>m_qvd1month</P><P>jan</P><P>feb</P><P>mar</P><P>apr</P><P>may</P><P>jun</P><P>jul</P><P>ago</P><P>sep</P><P>oct</P><P>nov</P><P>dec</P><P></P><P></P><P>QDV3 Result:</P><P>n_qvd1month</P><P>1</P><P>7</P><P>12</P><P></P><P>QVD3 should return values from 1 to 12, but it return only 1,7 and 12. I want to preserve the month name but the join is not correct because of the problem I just described.</P><P>Please any help.</P><P></P><P>Tank you in advance.</P><P>Diego.</P></BODY></HTML> Thu, 21 Jan 2016 21:46:01 GMT https://community.qlik.com/t5/QlikView/Problems-Joining-QVDs/m-p/1050777#M940744 2016-01-21T21:46:01Z Re: Problems Joining QVDs https://community.qlik.com/t5/QlikView/Problems-Joining-QVDs/m-p/1050778#M940745 <HTML><HEAD></HEAD><BODY><P>Also your QVD2 results are kind of strange (Month of a month should not return a month (or more precisely, not a range of months).</P><P></P><P>Could you please upload a QVD that shows this <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">qvd1month field?</SPAN></P></BODY></HTML> Thu, 21 Jan 2016 22:06:11 GMT https://community.qlik.com/t5/QlikView/Problems-Joining-QVDs/m-p/1050778#M940745 swuehl 2016-01-21T22:06:11Z