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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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))