topic Calculated Dimension to show All Hours in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension-to-show-All-Hours/m-p/663529#M1068785 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to show a chart that Sum the field <EM>Counter</EM> and show it with an hour dimension.</P><P>I have a field called <EM>Hour</EM>, that contains the hours, but some hour are missing, because there are no data for that hours.</P><P></P><P>So want I want is to make a "Calculated Dimension" with the 24 hours, and sum the field <EM>Counter</EM> for each hour.</P><P>How can I make the calculated dimension?</P><P></P><P>The expression that I'm using is: =Sum(Counter)</P><P>And the Dimension is= Hour</P><P></P><P><IMG alt="Hour.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/65377_Hour.png" style="width: 620px; height: 188px;" /></P></BODY></HTML> Wed, 27 Aug 2014 14:54:35 GMT cristian_av 2014-08-27T14:54:35Z Calculated Dimension to show All Hours https://community.qlik.com/t5/QlikView/Calculated-Dimension-to-show-All-Hours/m-p/663529#M1068785 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to show a chart that Sum the field <EM>Counter</EM> and show it with an hour dimension.</P><P>I have a field called <EM>Hour</EM>, that contains the hours, but some hour are missing, because there are no data for that hours.</P><P></P><P>So want I want is to make a "Calculated Dimension" with the 24 hours, and sum the field <EM>Counter</EM> for each hour.</P><P>How can I make the calculated dimension?</P><P></P><P>The expression that I'm using is: =Sum(Counter)</P><P>And the Dimension is= Hour</P><P></P><P><IMG alt="Hour.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/65377_Hour.png" style="width: 620px; height: 188px;" /></P></BODY></HTML> Wed, 27 Aug 2014 14:54:35 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-to-show-All-Hours/m-p/663529#M1068785 cristian_av 2014-08-27T14:54:35Z