Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My data are :
load * Inline
[Group,ID,Value
A,ID1,12
A,ID1,15
A,ID2,10
B,ID1,3
B,ID3,14];
On a pivot table, I count distinct ID by Group
I would like to get a total IDs of 4 : 2 IDs per group, and QlikView gives a total of 3 because ID1 participates to group A and B.
How can I get the total I expect?
The example is attached
Thanks
Pierre.
Looks like you want it distinct by Group and ID together. See attached.
Tom
Looks like you want it distinct by Group and ID together. See attached.
Tom