Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
mihai_iov
Contributor 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
Tags (2)
1 Solution

Accepted Solutions

Re: Sum distinct in set expression?

May be this

Count(DISTINCT Date_Used)

2 Replies

Re: Sum distinct in set expression?

May be this

Count(DISTINCT Date_Used)

mihai_iov
Contributor II

Re: Sum distinct in set expression?

Thanks, it works!