How many distinct X-Dim-Values are there per Y-Dim-Value

[Anonymous]

Hi,

I didnt find an answer for this. X-Dim and Y-Dim are even in the same table, but I didnt found a formula that works in this kind of table(total, aggr)... :

X	Y	CountXperY
1	1	3
2	1	3
3	1	3
4	2	2
5	2	2
6	3	1

Hope you can help me. Thanks alot. 🙂

Best regards

[OmarBenSalem]

count(total <Y> X)

Result : 

[Anonymous]

Thanks for your help, but Im sorry, I made a slight mistake.

I need this value without the Y-Dimension in the table:

X	X per Y
1	3
2	3
3	3
4	2
5	2

I hope this is possible with Qlik. 

Best regards. 

[Rohan]

Hello,

Please try the below mentioned code.

A :
load * inline [
x,y
1,1
2,1
3,1
4,2
5,2
6,3
];

B :
Load y,
(Count(x)) as x_p
Resident A Group by y;

Also, let me know if it works for you as well.

[OmarBenSalem · Accepted solution]

aggr(count({<X>}total <Y> X),Y,X)

Result:

[Anonymous]

Thanks alot thats great!