topic Problems with gaps and sorting in bar chart in QlikView https://community.qlik.com/t5/QlikView/Problems-with-gaps-and-sorting-in-bar-chart/m-p/607777#M224397 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a simple table of projects, with the fields Project (unique), Responsible, and EndDate.&nbsp; I am trying to chart these as 2 dimensions and an expression in a horizontal bar chart.&nbsp; The goal is to show a simple timeline from today onwards of which projects each person Responsible has been tasked with.&nbsp; If I group the bars, I get gaps because QV forces a placeholder for all possible values of the 2nd dimension (Responsible) even though there can only ever be 1 value per Project.&nbsp; I tried stacking instead (since there is only 1 2nd dimension value or expression per 1st dimension value anyway) and the chart comes up blank in v10.&nbsp; It does display in v11, but I am restricted to v10 for the forseeable future.&nbsp; Stacking resolves the gap problem in v11 but fails in v10.</P><P></P><P>The other issue I have is the sort.&nbsp; The customer wants to see the chart sorted by 2nd dimension (Responsible) and then EndDate.&nbsp; I cannot make it work no matter how many options/expressions I have tried.</P><P></P><P>We all know a picture or chart is worth 1,000 words, so please see the attached file.&nbsp; It has a sample table of data, 2 chart variations I have tried, and a mockup image of what I need the final result to look like.&nbsp; If anyone can provide a solution and explanation I would VERY much appreciate it.</P><P>Thanks,</P><P>Rich</P></BODY></HTML> Tue, 04 Feb 2014 19:00:43 GMT 2014-02-04T19:00:43Z Problems with gaps and sorting in bar chart https://community.qlik.com/t5/QlikView/Problems-with-gaps-and-sorting-in-bar-chart/m-p/607777#M224397 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a simple table of projects, with the fields Project (unique), Responsible, and EndDate.&nbsp; I am trying to chart these as 2 dimensions and an expression in a horizontal bar chart.&nbsp; The goal is to show a simple timeline from today onwards of which projects each person Responsible has been tasked with.&nbsp; If I group the bars, I get gaps because QV forces a placeholder for all possible values of the 2nd dimension (Responsible) even though there can only ever be 1 value per Project.&nbsp; I tried stacking instead (since there is only 1 2nd dimension value or expression per 1st dimension value anyway) and the chart comes up blank in v10.&nbsp; It does display in v11, but I am restricted to v10 for the forseeable future.&nbsp; Stacking resolves the gap problem in v11 but fails in v10.</P><P></P><P>The other issue I have is the sort.&nbsp; The customer wants to see the chart sorted by 2nd dimension (Responsible) and then EndDate.&nbsp; I cannot make it work no matter how many options/expressions I have tried.</P><P></P><P>We all know a picture or chart is worth 1,000 words, so please see the attached file.&nbsp; It has a sample table of data, 2 chart variations I have tried, and a mockup image of what I need the final result to look like.&nbsp; If anyone can provide a solution and explanation I would VERY much appreciate it.</P><P>Thanks,</P><P>Rich</P></BODY></HTML> Tue, 04 Feb 2014 19:00:43 GMT https://community.qlik.com/t5/QlikView/Problems-with-gaps-and-sorting-in-bar-chart/m-p/607777#M224397 2014-02-04T19:00:43Z Re: Problems with gaps and sorting in bar chart https://community.qlik.com/t5/QlikView/Problems-with-gaps-and-sorting-in-bar-chart/m-p/607778#M224398 <HTML><HEAD></HEAD><BODY><P>pls check 2nd chart...</P></BODY></HTML> Tue, 04 Feb 2014 19:36:49 GMT https://community.qlik.com/t5/QlikView/Problems-with-gaps-and-sorting-in-bar-chart/m-p/607778#M224398 MK_QSL 2014-02-04T19:36:49Z Re: Problems with gaps and sorting in bar chart https://community.qlik.com/t5/QlikView/Problems-with-gaps-and-sorting-in-bar-chart/m-p/607779#M224399 <HTML><HEAD></HEAD><BODY><P>Please check enclosed file...</P></BODY></HTML> Tue, 04 Feb 2014 19:37:33 GMT https://community.qlik.com/t5/QlikView/Problems-with-gaps-and-sorting-in-bar-chart/m-p/607779#M224399 MK_QSL 2014-02-04T19:37:33Z Re: Problems with gaps and sorting in bar chart https://community.qlik.com/t5/QlikView/Problems-with-gaps-and-sorting-in-bar-chart/m-p/607780#M224400 <HTML><HEAD></HEAD><BODY><P>Thanks for the quick response.&nbsp; I see the desired results in you chart in v11, but when I open the file in v10 there are no bars in it (see attached).&nbsp; I didn't see any v11-specific features <IMG alt="chart.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/52593_chart.jpg" /></P></BODY></HTML> Tue, 04 Feb 2014 19:49:23 GMT https://community.qlik.com/t5/QlikView/Problems-with-gaps-and-sorting-in-bar-chart/m-p/607780#M224400 2014-02-04T19:49:23Z