Discussion Board for collaboration on QlikView Scripting.
Hi, i have this situation::
I want to show in qlikview TableA and TableB, but in TableB only the rows that number from TableB exist in TableA. The way it is now, it shows:
How can I do that? Is there a way to do without create a 3rd table ? maybe with "where exists", but how?
Go to Solution.
This is what you can do to accomplish this:
Not sure I understand, but if you have a straight table dimensioned with the field "number", then the expression =Only(nameB) will display the way you show in your example.
If you want to show the nulls, then ensure that the suppress zero and suppress null options are off.
I think best option is to use LEFT KEEP, meaning Table B will only show common fields.
LEFT KEEP (TableA)
Hope this is helpful?
Swap the order and use left keep.
Thank you all, Philippe Grenier answer is what I was looking for.