count set analysis

[nicolai_moller]

Hi

I'm trying to write an expression (in an pivot table) with a set analysis that counts the number of goods that a department has received.

At the moment it only shows the department where the good is currently located, which in some cases is different from the receiving department.

The problem is that they have different IDs, so the column with 'Goods received Department' has one name but a different one in 'Goods Department, even though it is the same department. The two fields are mapped together in QlikView though.

I want the 'Goods Deparment' to count the number of goods it has received, even though some goods may not exist there anymore. But the pivot table should only show the 'Goods Deparment' and not 'Goods Received Department'.

Goods Department	Goods Received Department	Goods ID
A	P1	123
B	P1	124
B	P1	125
C	P2	126
C	P2	127
D	P3	128

So if P1 = A, then A should count 3 (instead of 1 in the table above) and if P2 = D, then D should count 2.

Thanks.

[#2]

Er du blevet certificeret? Hvorfor sidder i med qlikview? Kan du ikke lige give mig din mail?

[nicolai_moller]

Jeg sidder på nmp@ankl.dk