Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
count(total <Y> X)
Result :
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.
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.
aggr(count({<X>}total <Y> X),Y,X)
Result:
Thanks alot thats great!