Discussion board where members can get started with QlikView.
I want to show a chart that Sum the field Counter and show it with an hour dimension.
I have a field called Hour, that contains the hours, but some hour are missing, because there are no data for that hours.
So want I want is to make a "Calculated Dimension" with the 24 hours, and sum the field Counter for each hour.
How can I make the calculated dimension?
The expression that I'm using is: =Sum(Counter)
And the Dimension is= Hour