topic Combo chart -show missing intervals in QlikView https://community.qlik.com/t5/QlikView/Combo-chart-show-missing-intervals/m-p/1041881#M350562 <HTML><HEAD></HEAD><BODY><P>Hi all, bit of a newbie here, need your help please!</P><P></P><P>We have various companies (DNO's) that submit a set of files (A-H) for each month.</P><P></P><P>I'm trying to generate a combo bar chart which will visually display any missing files.</P><P></P><P>I have attached an example of what the chart would look like if all files were submitted but I want to see a white section (block) for any file types that are missing for that particular month for a specific company.</P><P></P><P>The DNO table has the actual files submitted by the companies and the SectionExpected table is just something I tried generating as a table that contains all combinations of Company and Section but not quite sure how to model it or what expressions I need to use to make the chart appear as desired.</P><P></P><P></P><P>Any help much appreciated!!!</P></BODY></HTML> Wed, 03 Feb 2016 19:00:58 GMT 2016-02-03T19:00:58Z Combo chart -show missing intervals https://community.qlik.com/t5/QlikView/Combo-chart-show-missing-intervals/m-p/1041881#M350562 <HTML><HEAD></HEAD><BODY><P>Hi all, bit of a newbie here, need your help please!</P><P></P><P>We have various companies (DNO's) that submit a set of files (A-H) for each month.</P><P></P><P>I'm trying to generate a combo bar chart which will visually display any missing files.</P><P></P><P>I have attached an example of what the chart would look like if all files were submitted but I want to see a white section (block) for any file types that are missing for that particular month for a specific company.</P><P></P><P>The DNO table has the actual files submitted by the companies and the SectionExpected table is just something I tried generating as a table that contains all combinations of Company and Section but not quite sure how to model it or what expressions I need to use to make the chart appear as desired.</P><P></P><P></P><P>Any help much appreciated!!!</P></BODY></HTML> Wed, 03 Feb 2016 19:00:58 GMT https://community.qlik.com/t5/QlikView/Combo-chart-show-missing-intervals/m-p/1041881#M350562 2016-02-03T19:00:58Z