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:
Go to Solution.
May be this
Thanks, it works!