4 Replies Latest reply: Dec 14, 2017 9:10 PM by Anil Samineni RSS

    Combo Chart: Stacked Bar Two Dimension >1 Expression

    Ibrahim Aslan

      Hi Friends,

       

      following problem:

       

      I have a Combo Chart with two Dimensions.

      1. Year

      2. Product Group

       

      In the Chart I want to show:

       

      1. Expression:  per Year the sum of Amount per Product Group in stacked bar (sum(amount)

      2. Expression: first Expression * 115% in Lines (sum(amount) * 1,15)

      3. Expression: a fixed target value in Lines (This can possibly solved with a reference line in presentation)

       

      QlikView makes automatically o grouped bar if I have a second expression.

      There are over 100 product groups available, so I can't do it with set analysis for every product group.

       

      thanks for your tips