Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Issue with left keep

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.

From this qvw, it looks like left join and left keep behave the same way. Please have a look.

Thanks

Ram

1 Solution

Accepted Solutions

Re: Issue with left keep

No, tab3 has only two records. Just as you expect. But the key "country" of course has more values.

HIC

left keep.png

3 Replies

Re: Issue with left keep

No, tab3 has only two records. Just as you expect. But the key "country" of course has more values.

HIC

left keep.png

Not applicable

Re: Issue with left keep

Thanks Henric. Got the crux of it now.

Not applicable

Re: Issue with left keep

Thanks Henric. Got the crux of it now.

Community Browser