Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am new in Qlik and get the table like this:
pkg | time | h_act | d_act |
A | 7 | 1 | 2 |
A | 6 | 2 | 2 |
B | 8 | 3 | 3 |
B | 9 | 1 | 3 |
C | 10 | 2 | 2 |
D | 11 | 6 | 6 |
where pkg means app that users user, time means different times in day, h_act means how many users in one time, d_act means how many users in one day.
Is that possiable for me to gourp the data by pkg and time and get sumed distinct value of d_act and as i choose different pkg, the value can change automatically?
Thanks!
In terms of output, what do you expect? or perhaps as below.
Sum(Aggr(Sum(DISTINCT d_act), pkg, time))