topic Auto-drill-down chart when Null values present? in QlikView https://community.qlik.com/t5/QlikView/Auto-drill-down-chart-when-Null-values-present/m-p/318245#M1188736 <HTML><HEAD></HEAD><BODY><P>I have a multi-dimensional grid chart where the second dimension is a group (for drill-down year -&gt; month -&gt; date -&gt; hour). This group keys off a field that may contain null values. I can avoid having these show up in the chart as "-" by clicking the "Supress when value is null" and this works great. </P><P></P><P>One feature I do like is how the groups will automatically skip group members that don't have data (auto drill-down). So I have a button that filters to "Today" and so the chart automatically drills-down to the hour level.. if there are no Null values returned. If there are Null values, though, the group will start at the top level (year) and not auto-drill-down. If I uncheck "Suppress when value is null" I do see the Null entry next to the Year.</P><P></P><P>Is there a way, maybe through an expression in the groups, to completely omit rows in the table that contain the Null values, or some other method so that the chart will auto-drill-down? I can't remove the Null rows from the SQL query because those rows are necessary on other sheets... </P></BODY></HTML> Thu, 01 Sep 2011 18:28:52 GMT 2011-09-01T18:28:52Z Auto-drill-down chart when Null values present? https://community.qlik.com/t5/QlikView/Auto-drill-down-chart-when-Null-values-present/m-p/318245#M1188736 <HTML><HEAD></HEAD><BODY><P>I have a multi-dimensional grid chart where the second dimension is a group (for drill-down year -&gt; month -&gt; date -&gt; hour). This group keys off a field that may contain null values. I can avoid having these show up in the chart as "-" by clicking the "Supress when value is null" and this works great. </P><P></P><P>One feature I do like is how the groups will automatically skip group members that don't have data (auto drill-down). So I have a button that filters to "Today" and so the chart automatically drills-down to the hour level.. if there are no Null values returned. If there are Null values, though, the group will start at the top level (year) and not auto-drill-down. If I uncheck "Suppress when value is null" I do see the Null entry next to the Year.</P><P></P><P>Is there a way, maybe through an expression in the groups, to completely omit rows in the table that contain the Null values, or some other method so that the chart will auto-drill-down? I can't remove the Null rows from the SQL query because those rows are necessary on other sheets... </P></BODY></HTML> Thu, 01 Sep 2011 18:28:52 GMT https://community.qlik.com/t5/QlikView/Auto-drill-down-chart-when-Null-values-present/m-p/318245#M1188736 2011-09-01T18:28:52Z