Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Fattyjody
Contributor
Contributor

How to sum disinct value in groups

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!

Labels (3)
1 Reply
BrunPierre
Partner - Master II
Partner - Master II

In terms of output, what do you expect? or perhaps as below.

Sum(Aggr(Sum(DISTINCT d_act), pkg, time))