6 Replies Latest reply: Jan 21, 2013 11:20 AM by Michael Ionkin RSS

    Calculation inside of a diagramm / chart

    Michael Ionkin

      Hello,

       

      I have the following problem:

       

      I have a Table with different states and time linked to this state

      StateDuration
      State_11
      State_21.5
      State_345
      State_32

       

      What I did was putting the State as dimension and sum(Duration) as formula.

      The problem now is , that I have to split the State_3 in 3 other substates.

       

      I tried the following: I put the State our of dimentions and added every State as formula

      (If(State=State_1;sum(duration);0)

      and called the formula State_1.

       

      Unfortunatly QlikView is showing me always 0 as the result..

       

      Any idea?

       

      Cheers chesterluck