topic Breaks in Data in QlikView https://community.qlik.com/t5/QlikView/Breaks-in-Data/m-p/1381601#M810601 <HTML><HEAD></HEAD><BODY><P>Hello All, </P><P></P><P>I am having trouble breaks in data. I am trying to create a straight table that shows me when data is not entered into a database. I will attach a mocked up version of what i am trying to accomplish. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT mparker123 2020-11-25T16:16:04Z Breaks in Data https://community.qlik.com/t5/QlikView/Breaks-in-Data/m-p/1381601#M810601 <HTML><HEAD></HEAD><BODY><P>Hello All, </P><P></P><P>I am having trouble breaks in data. I am trying to create a straight table that shows me when data is not entered into a database. I will attach a mocked up version of what i am trying to accomplish. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Breaks-in-Data/m-p/1381601#M810601 mparker123 2020-11-25T16:16:04Z Re: Breaks in Data https://community.qlik.com/t5/QlikView/Breaks-in-Data/m-p/1381602#M810602 <HTML><HEAD></HEAD><BODY><P>Try this as your dimension</P><P></P><P><STRONG>=Aggr(If(Sum(HOURS) = 0 and DEPT = '44840', LAN_ID), LAN_ID, MONTH, DAY_NUMBER, YEAR)</STRONG></P></BODY></HTML> Mon, 02 Oct 2017 17:04:26 GMT https://community.qlik.com/t5/QlikView/Breaks-in-Data/m-p/1381602#M810602 sunny_talwar 2017-10-02T17:04:26Z