topic lost in dimension and expression .. bar chart in QlikView https://community.qlik.com/t5/QlikView/lost-in-dimension-and-expression-bar-chart/m-p/228381#M80417 <HTML><HEAD></HEAD><BODY><P>what the problems is, that the 4 column have no relation.. i need to group them.</P><P>the group will contain 4 items. Then i can put the group in the dimension .. and do a sum(value) in expression. This will give me (i hope) a 4 bar chart.</P><P>but how can i group them based on let say column position or column name from excel as source?</P><P></P><P></P><P></P><P></P></BODY></HTML> Mon, 01 Feb 2010 23:41:32 GMT amien 2010-02-01T23:41:32Z lost in dimension and expression .. bar chart https://community.qlik.com/t5/QlikView/lost-in-dimension-and-expression-bar-chart/m-p/228379#M80415 <HTML><HEAD></HEAD><BODY><P>i have 4 columns as data source. each column is a category.</P><P>in 4 bars i want all 4 categories .. and then a sum of it of each catergory.</P><P>i now have in dimension all 4 categories .. and then 4x sum in expression.</P><P>but this is not really working</P><P></P><P></P></BODY></HTML> Mon, 01 Feb 2010 22:08:32 GMT https://community.qlik.com/t5/QlikView/lost-in-dimension-and-expression-bar-chart/m-p/228379#M80415 amien 2010-02-01T22:08:32Z lost in dimension and expression .. bar chart https://community.qlik.com/t5/QlikView/lost-in-dimension-and-expression-bar-chart/m-p/228380#M80416 <HTML><HEAD></HEAD><BODY><P>I don't think I understand, but maybe this?</P><P style="padding-left:30px;">Expression1 = sum(category1)<BR />Expression2 = sum(category2)<BR />Expression3 = sum(category3)<BR />Expression4 = sum(category4)<BR />Expression5 = rangesum(Expression1,Expression2,Expression3,Expression4)</P><P>Use a combo chart, first four expressions displayed as stacked bars, fifth expression displayed as text on data point and an invisible symbol?</P></BODY></HTML> Mon, 01 Feb 2010 22:53:16 GMT https://community.qlik.com/t5/QlikView/lost-in-dimension-and-expression-bar-chart/m-p/228380#M80416 johnw 2010-02-01T22:53:16Z lost in dimension and expression .. bar chart https://community.qlik.com/t5/QlikView/lost-in-dimension-and-expression-bar-chart/m-p/228381#M80417 <HTML><HEAD></HEAD><BODY><P>what the problems is, that the 4 column have no relation.. i need to group them.</P><P>the group will contain 4 items. Then i can put the group in the dimension .. and do a sum(value) in expression. This will give me (i hope) a 4 bar chart.</P><P>but how can i group them based on let say column position or column name from excel as source?</P><P></P><P></P><P></P><P></P></BODY></HTML> Mon, 01 Feb 2010 23:41:32 GMT https://community.qlik.com/t5/QlikView/lost-in-dimension-and-expression-bar-chart/m-p/228381#M80417 amien 2010-02-01T23:41:32Z lost in dimension and expression .. bar chart https://community.qlik.com/t5/QlikView/lost-in-dimension-and-expression-bar-chart/m-p/228382#M80418 <HTML><HEAD></HEAD><BODY><P>see example ... i came up with loading the data 4 times ..</P></BODY></HTML> Tue, 02 Feb 2010 00:11:51 GMT https://community.qlik.com/t5/QlikView/lost-in-dimension-and-expression-bar-chart/m-p/228382#M80418 amien 2010-02-02T00:11:51Z lost in dimension and expression .. bar chart https://community.qlik.com/t5/QlikView/lost-in-dimension-and-expression-bar-chart/m-p/228383#M80419 <HTML><HEAD></HEAD><BODY><P>I'm getting lost in expressions too!!! I have a simple data source. Data are classified as follow: Class, product, sales splitted over three years. I have to calculate Year to date and Moving annual total for every product...I already tried different expressions but they don't work at all? Does anyone know how to do that...</P><P>Thanks in advance for your help.</P><P>PS: I have Qw personal edition, please make the attached file downloadable to me</P><P>Thanks again</P></BODY></HTML> Tue, 02 Feb 2010 10:55:58 GMT https://community.qlik.com/t5/QlikView/lost-in-dimension-and-expression-bar-chart/m-p/228383#M80419 2010-02-02T10:55:58Z