3 Replies Latest reply: Jun 12, 2014 11:59 AM by Clever Anjos RSS

    Sort in Graph

      Hi All,

      I want to put interactive sort on my Chart.

      And color those arrows for chart sort.

      this sort should work ascending and descending as well.

       

        • Re: Sort in Graph
          Clever Anjos

          Please check if fits your needs.

          You can improve layout later

            • Re: Sort in Graph

              Actually I am using Personal Edition.

                • Re: Sort in Graph
                  Clever Anjos

                  What I´ve done

                  1) Created one variable vSort

                  2) Created one textbox, configurated as image and with this expression:

                  =if(vSort=1,'qmem://<bundled>/BuiltIn/arrow_n_r.png',

                  if(vSort=2,'qmem://<bundled>/BuiltIn/arrow_s_r.png',

                  'qmem://<bundled>/BuiltIn/arrow_e.png'))

                  3) Attached one action "Set Variable" with expression =if(vSort=1,2,1)

                  4) Created one textbox, configurated as image and with this expression:

                  =if(vSort=3,'qmem://<bundled>/BuiltIn/arrow_n_r.png',

                  if(vSort=4,'qmem://<bundled>/BuiltIn/arrow_s_r.png',

                  'qmem://<bundled>/BuiltIn/arrow_e.png'))

                  5) Attached one action "Set Variable" with expression =if(vSort=3,4,3)

                  6) Created one textbox, configurated as image and with this expression:

                  =if(vSort=5,'qmem://<bundled>/BuiltIn/arrow_n_r.png',

                  if(vSort=6,'qmem://<bundled>/BuiltIn/arrow_s_r.png',

                  'qmem://<bundled>/BuiltIn/arrow_e.png'))

                  7) Attached one action "Set Variable" with expression =if(vSort=5,6,5)

                  8) Used this expression as Sort Order of my table

                  Pick(vSort,

                  -sum(Expression1),

                  sum(Expression1),

                  -sum(Expression2),

                  sum(Expression2),

                  -sum(Expression3),

                  sum(Expression3)

                  )

                   

                  Capturar.PNG.png

                  Capturar2.PNG.png

                  Capturar3.PNG.png

                  Capturar4.PNG.png