8 Replies Latest reply: Oct 23, 2012 4:50 AM by Niklas Harding RSS

    Grouping of values in a barchart

    Niklas Harding

      Hi QC

       

      I have a problem i havent been able to solve... the x-axe shows time (in days) and y-axe shows amount.

       

      I wanted to group days 0 - 4 and its values (the green bars below) in one bar, then days 5 - 9 in one bar (the orange bars) and so forth...

       

      Ive done this in excel on the same data by grouping the days 0 - 4 in a pivot table and make the chart based on the data from the pivot table, but i havent been able to pull it off in Qlikview.

       

      Days are entered as a dimension and amount as an expression, and the chart is made in the QV IE Plugin.

       

      Anybody have a solution on how to do this?

       

      chart grouping.jpg