1 Reply Latest reply: Jul 12, 2011 6:53 PM by Emmanuel Prieto RSS

    Dinamic group in qlikview 9

    marcelo gonzalez

      Hello,

      I need help in a pivot table when i want to create groups from an expression.

      I have a list of clients with the sales of two years:

       

      Client    SaleYear1  SaleYear2    Evolution

      Gran Khors S.A.

       

      12

       

      40

       

      233%

       

      Frescar S.A.

       

      176

       

      584

       

      232%

       

      Crosetti German Marcelo

       

      15

       

      42

       

      180%

       

      Rabellini Butori Carlos I.

       

      20

       

      14

       

      -30%

       

      Parque Srl

       

      33

       

      23

       

      -30%

       

       

      I want to creat a group with all de clients that have negative evolution (4 y 5)  and other group with the one who has positive evolution (1,2,3)

      I tried creating  a Dimension with the following expression:if((saleyear 1 – Saleyear2)<0, Group1,Group2)   but it does not work

      Thanks