9 Replies Latest reply: Feb 2, 2016 10:48 AM by Sunny Talwar RSS

    Dimension Limits

    Naresh Guntur

      I have a table

       

      LOAD * INLINE [

          F1, F2, F3

          a1, 1, 6

          a2, 2, 5

          a3, 3, 4

          a4, 4, 3

          a5, 5, 2

          a6, 6, 1

      ];

       

       

      and my chart gives me this

      F1 sum(F2-F3)
      0
      a1-5
      a2-3
      a3-1
      a41
      a53
      a65

       

       

       

      and I wanted to get only negative values

       

      F1 if(sum(F2-F3)<0,sum(F2-F3))
      a1-5
      a2-3
      a3-1

       

      and I wanted to get the smallest 2, basically -5 and -3 and so I applied for Dimension Limits.

       

      and I don't get any data

       

      F1 if(sum(F2-F3)<0,sum(F2-F3))

       

       

       

      Attached is the qvw.