9 Replies Latest reply: Sep 1, 2016 8:02 AM by Arabela Rondic RSS

    Qlikview - bar chart with multiple dimensions

    Arabela Rondic

      I have straight table with lot of data...

      enter image description here

      I need to create bar chart from this table - dimension to be year and expressions Column(1)-Column(2).

        column(1) = sum(Saldo) column(2) = sum(Saldo)/3

      I try to set dimension to be year and expresion

                 sum(sum(Saldo) - (sum(Saldo)/3))

       

      but I don't get same total like I get sum of rows of Column(1)-Column(2).

      This is because I need to include in dimension Line.

      How can I create bar chart with dimensions I have in straight table...?

      Any idea?