Interested in your thoughts on how to handle this.
Still feel quite new with Qlikview and I've ran into a bit of a struggle with the following situation.
How do I count the Vendors NOT in Table B (Vendor A and B) with Vendor acting as a Key between the two tables. The result I'm looking for in the example below is 2. Is there anyway to specify exactly what I'd like to be counted count(Table A.Vendor) - count(Table B.Vendor) ?
This eliminates all the vendors in B and only keeps the vendors in A that are needed for counting. This also reduces the size of your data and maintains your optimized load (assuming you are using .qvd's). The downside here is that you are throwing out data. Verify that you don't need it later in the load.
Thanks everyone for your answers. I wanted to keep the original data in tact so I picked the answer that solved the issue that way. The other ways certainly work and are probably more efficient, but I wasn't looking for efficiency here.