topic Boxplot does not acccount for instances with zero counts in QlikView https://community.qlik.com/t5/QlikView/Boxplot-does-not-acccount-for-instances-with-zero-counts/m-p/363156#M578556 <HTML><HEAD></HEAD><BODY><P>I have a list of different types of transactions per day. I can count the number of transactions per type per day and then create a boxplot over all days and even more I can create those boxplot by weekday. I use a filter to look for a particular transactions boxplots, day of week as dimension and then an expression to aggregate the counts. However, when the count of that transaction is zero for a date, the boxplot does not take into account that date so the fractiles are wrong. For instance, if transaction type A happend 2 times over one date out of 365, my boxplot looks like all the fractiles are 2 when they should be zero. Any ideas? thanks. </P><P>This is the expression I am using in the boxplot fractiles:</P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 8pt;">Fractile(aggr(count(transactionID),appt_date),0.25)</SPAN></P><P></P></BODY></HTML> Wed, 21 Mar 2012 17:11:58 GMT 2012-03-21T17:11:58Z Boxplot does not acccount for instances with zero counts https://community.qlik.com/t5/QlikView/Boxplot-does-not-acccount-for-instances-with-zero-counts/m-p/363156#M578556 <HTML><HEAD></HEAD><BODY><P>I have a list of different types of transactions per day. I can count the number of transactions per type per day and then create a boxplot over all days and even more I can create those boxplot by weekday. I use a filter to look for a particular transactions boxplots, day of week as dimension and then an expression to aggregate the counts. However, when the count of that transaction is zero for a date, the boxplot does not take into account that date so the fractiles are wrong. For instance, if transaction type A happend 2 times over one date out of 365, my boxplot looks like all the fractiles are 2 when they should be zero. Any ideas? thanks. </P><P>This is the expression I am using in the boxplot fractiles:</P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 8pt;">Fractile(aggr(count(transactionID),appt_date),0.25)</SPAN></P><P></P></BODY></HTML> Wed, 21 Mar 2012 17:11:58 GMT https://community.qlik.com/t5/QlikView/Boxplot-does-not-acccount-for-instances-with-zero-counts/m-p/363156#M578556 2012-03-21T17:11:58Z