2 Replies Latest reply: Oct 6, 2017 3:57 PM by pradosh thakur RSS

    Button

    Anil danda

      Hello Qlik Experts

      I have a pivot table in which i am displaying the amount in millions. When i export to excel the values are showing in M like 100M. The users are asking to create a button where we can select the value as millions or complete amount.  Can someone help me please?

        • Re: Button
          Vineeth Pujari

          Give a list to toggle example

           

          load * inline [

          ShowIn,DivVal

          $M,1000000    <<Millions

          $K,1000          <<thousands

          $,1                       <<As Is

          ];      

           

          change expressions to refer to selected DivVal

           

          examples Sum(Sales) / DivVal

          • Re: Button
            pradosh thakur

            Create a variable v1 and set its value as zero.

            Use the button to toggle the value of v1 between 0 and 1.

            Create two columns one with M and another with complete count

            Put conditional show hide for both as v1=0 for millions and v1=1 for complete count.

             

            Now export to Excel.

             

            Regards

            Pradosh