topic grouped bar chart with 3 dimensions in QlikView https://community.qlik.com/t5/QlikView/grouped-bar-chart-with-3-dimensions/m-p/336884#M575520 <HTML><HEAD></HEAD><BODY><P> I have normally a time and category dimension to show my data in a bar chart</P><P></P><P>I have been asked to show a grouped bar chart for some special cases, let me call it "Fixed". I have added a Flag (0/1) in the fact table to represent "Fixed".<BR />I can show the bars with the expression sum( if(Fixed = 1, Value, 0))<BR />This however will not filter my lists based on the "Fixed" setting when I select the bars.<BR />If I add the "Fixed" flag as a dimension and use sum(Value) as expression the filtering works but now the grouped bar chart automatically turns into a stacked bar.<BR />Do I need to create a concatenated dimension "category + Fixed", a calculated dimension or is there a setting to force the grouped bars?</P><P><BR />Juerg</P></BODY></HTML> Tue, 05 Jun 2012 07:20:29 GMT 2012-06-05T07:20:29Z grouped bar chart with 3 dimensions https://community.qlik.com/t5/QlikView/grouped-bar-chart-with-3-dimensions/m-p/336884#M575520 <HTML><HEAD></HEAD><BODY><P> I have normally a time and category dimension to show my data in a bar chart</P><P></P><P>I have been asked to show a grouped bar chart for some special cases, let me call it "Fixed". I have added a Flag (0/1) in the fact table to represent "Fixed".<BR />I can show the bars with the expression sum( if(Fixed = 1, Value, 0))<BR />This however will not filter my lists based on the "Fixed" setting when I select the bars.<BR />If I add the "Fixed" flag as a dimension and use sum(Value) as expression the filtering works but now the grouped bar chart automatically turns into a stacked bar.<BR />Do I need to create a concatenated dimension "category + Fixed", a calculated dimension or is there a setting to force the grouped bars?</P><P><BR />Juerg</P></BODY></HTML> Tue, 05 Jun 2012 07:20:29 GMT https://community.qlik.com/t5/QlikView/grouped-bar-chart-with-3-dimensions/m-p/336884#M575520 2012-06-05T07:20:29Z