This content has been marked as final. Show 5 replies
Hi, Qlikview community
I have one problem that I need help to solve.
I want to count the amount of differenct Document Numbers. It should be pretty easy but that is a twist.
The Document Number can have the same for difference Company Code.
So I have one document number 52001186 for company code 1100 and the same document number for company code 1000.
Which means that I can't use DISTINCT.
When I use DISTINCT I get total of one document number.
I want the answer to be 2 because this is two company codes.
|Vendor Name||Company Code||Document Number|