topic Re: Issue with left keep in QlikView https://community.qlik.com/t5/QlikView/Issue-with-left-keep/m-p/388602#M1167625 <HTML><HEAD></HEAD><BODY><P>No, tab3 has only two records. Just as you expect. But the key "country" of course has more values.</P><P></P><P>HIC</P><P></P><P><IMG __jive_id="23036" class="jive-image" alt="left keep.png" src="/legacyfs/online/23036_left keep.png" /></P></BODY></HTML> Sun, 07 Oct 2012 07:19:09 GMT hic 2012-10-07T07:19:09Z Issue with left keep https://community.qlik.com/t5/QlikView/Issue-with-left-keep/m-p/388601#M1167623 <HTML><HEAD></HEAD><BODY><P><STRONG></STRONG></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Hi, I have two tabs tab1 and tab3. Tab 3 is left kept with tab1. Tab1 has a number of rows, but tab3 only has 2 rows. So I expect tab3 after left keep to have only 2 rows but it seems to contain 3 rows. I have attached my qvw. Please help.</SPAN></P><P></P><P><STRONG><STRONG style=": ; color: #0000ff; font-size: 8pt;">From this qvw, it looks like left join and left keep behave the same way. Please have a look.</STRONG></STRONG></P><P><STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG style=": ; color: #0000ff; font-size: 8pt;">Thanks</STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG style=": ; color: #0000ff; font-size: 8pt;">Ram</STRONG></STRONG></STRONG></STRONG></STRONG></P><P></P></BODY></HTML> Sun, 07 Oct 2012 06:10:56 GMT https://community.qlik.com/t5/QlikView/Issue-with-left-keep/m-p/388601#M1167623 2012-10-07T06:10:56Z Re: Issue with left keep https://community.qlik.com/t5/QlikView/Issue-with-left-keep/m-p/388602#M1167625 <HTML><HEAD></HEAD><BODY><P>No, tab3 has only two records. Just as you expect. But the key "country" of course has more values.</P><P></P><P>HIC</P><P></P><P><IMG __jive_id="23036" class="jive-image" alt="left keep.png" src="/legacyfs/online/23036_left keep.png" /></P></BODY></HTML> Sun, 07 Oct 2012 07:19:09 GMT https://community.qlik.com/t5/QlikView/Issue-with-left-keep/m-p/388602#M1167625 hic 2012-10-07T07:19:09Z Re: Issue with left keep https://community.qlik.com/t5/QlikView/Issue-with-left-keep/m-p/388603#M1167627 <HTML><HEAD></HEAD><BODY><P>Thanks Henric. Got the crux of it now.</P></BODY></HTML> Sun, 07 Oct 2012 07:40:16 GMT https://community.qlik.com/t5/QlikView/Issue-with-left-keep/m-p/388603#M1167627 2012-10-07T07:40:16Z Re: Issue with left keep https://community.qlik.com/t5/QlikView/Issue-with-left-keep/m-p/388604#M1167629 <HTML><HEAD></HEAD><BODY><P>Thanks Henric. Got the crux of it now.</P></BODY></HTML> Sun, 07 Oct 2012 07:40:21 GMT https://community.qlik.com/t5/QlikView/Issue-with-left-keep/m-p/388604#M1167629 2012-10-07T07:40:21Z