Discussion Board for collaboration on QlikView Extensions.
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.
Go to Solution.
In terms of expression, this is what Colin Albert means (if I am not wrong):
=Count(DISTINCT [Document Number] & [Company Code])
Checkout the text box object in the attached qvw.
Concatenate the Company Code & Document Number, and then calculate the distinct count.
Try this. This might help:
aggr(count(DISTINCT [Document Number]),[Company Code])
in case the numbers are not fixed length you could add a seperator to avoid collisions:
=Count(DISTINCT [Document Number] &'/'& [Company Code])
Hope this helps also.
The code below - removing dublicates.
if(Previous(ICS_Field)=ICS_Field,1,0) as Flag;
DROP Table Objects;
DROP Field Flag From tmpObjects;