Discussion board where members can get started with QlikView.
Hello, assuming I have the following table
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:
May be this
View solution in original post
Thanks, it works!