6 Replies Latest reply: Oct 11, 2012 11:28 AM by Len Smith RSS

    Cycling Multiple expressions

      Is there a way to cycle multple expressions at the same time? I have a tabular chart with thirteen columns, one for the customer name (the dimension), and one expression for each month. I'd like to be able to cycle from dollars to units in all twelve months simultaneously. Can this be done?

        • Re: Cycling Multiple expressions
          m w

          Write each expression something like this:

               if(vExprFlag = 1, sum(Dollars),sum(Units))

           

          Create a variable vExprFlag and set to 1.

          Create a button that cycles the value of the variable between 1 and 0 when clicked.

            • Re: Cycling Multiple expressions

              Thanks. That worked. As did Rebeccad's suggestion.

               

              Next question: Is it possible to change the column formatting
              dynamically from integer to money when I make the switch?

              Also, is there a good reference on the API? I looked at
              the API Guide.qvw but it looks pretty lame. I have a VB
              background but I'd like to find out more about the classes, properties
              and methods available.

              • Re: Cycling Multiple expressions

                Thanks. That worked. As did Rebeccad's suggestion.

                Next question: Is it possible to change the column formatting
                dynamically from integer to money when I make the switch?

                Also, is there a good reference on the API? I looked at
                the API Guide.qvw but it looks pretty lame. I have a VB
                background but I'd like to find out more about the classes, properties
                and methods available.

                • Re: Cycling Multiple expressions

                  Thanks. That worked. As did Rebeccad's suggestion.

                   

                  Next question: Is it possible to dynamically change the column formatting from integer to money when the switch from units to dollars occurs?

                   

                  Also, is there a good reference for the API? I looked at the API Guide.qvw but it seems pretty lame. I'd like to get a better handle on the classes, properties and methods available.

                • Re: Cycling Multiple expressions
                  Rebecca Molstad

                  What mwoolf has suggested will work. Another idea is to have a list box that contains 'Dollars' and 'Units', and the user can select which view they want to see.  See attached.