Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Calculated Dimension to show All Hours


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


0 Replies