Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mihai_iov
Creator II
Creator II

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)

View solution in original post

mihai_iov
Creator II
Creator II
Author

Thanks, it works!