topic How to create a frequency table including zero in QlikView https://community.qlik.com/t5/QlikView/How-to-create-a-frequency-table-including-zero/m-p/657947#M240145 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have been searching the community for the answer to my question but did not succeed so far. Hopefully someone here can help me.</P><P></P><P>I want to create a frequency table for the number of calls made per region. The dimensions are region and #calls (calculated, using the Aggr function). The expression is a count on distinct employee-id's.</P><P></P><P>When I do not select a timeperiod (ie year or month) I see the expected result for the total dataset. What I want to achieve is that when I do select a timeperiod the number of employees with zero calls is also shown.</P><P></P><P>I've attached my example.</P><P></P><P>Regards,</P><P>Jock</P></BODY></HTML> Wed, 11 Jun 2014 11:15:24 GMT 2014-06-11T11:15:24Z How to create a frequency table including zero https://community.qlik.com/t5/QlikView/How-to-create-a-frequency-table-including-zero/m-p/657947#M240145 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have been searching the community for the answer to my question but did not succeed so far. Hopefully someone here can help me.</P><P></P><P>I want to create a frequency table for the number of calls made per region. The dimensions are region and #calls (calculated, using the Aggr function). The expression is a count on distinct employee-id's.</P><P></P><P>When I do not select a timeperiod (ie year or month) I see the expected result for the total dataset. What I want to achieve is that when I do select a timeperiod the number of employees with zero calls is also shown.</P><P></P><P>I've attached my example.</P><P></P><P>Regards,</P><P>Jock</P></BODY></HTML> Wed, 11 Jun 2014 11:15:24 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-frequency-table-including-zero/m-p/657947#M240145 2014-06-11T11:15:24Z