Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum distinct in set expression?

Hello, assuming I have the following table

Computer_IDDate_UsedOn_State
11.01.20171
21.01.20171
31.01.20171
11.01.20171
21.01.20171
11.01.20171
33.01.20171

how can I sum all the days all the computers have been used on "On_State" = 1 without adding the duplicates? Is there any way to use DISTINCT in Sum's Set Expression?

I'm looking for the following output for the said expression(in a PivotTable), given the table above:

Computer_IDDays_used
11
21
32
1 Solution

Accepted Solutions
sunny_talwar

May be this

Count(DISTINCT Date_Used)

View solution in original post

2 Replies
sunny_talwar

May be this

Count(DISTINCT Date_Used)

Anonymous
Not applicable
Author

Thanks, it works!