6 Replies Latest reply: Oct 28, 2012 9:12 AM by Stefan Wühl RSS

    Conversion factor

      Hi,

       

      can anyone know about conversion factor.

      I am having table with ProductID,ProductgroupID,Factorvalue.

       

      I want to multiply this Factorvalue with productid.

      How can i do this in qlikview.

       

      any help..

       

       

      Thanks,

      baru

        • Re: Conversion factor
          Gysbert Wassenaar

          If both ProductID and Factorvalue are numbers you can calculate the product of the two as a new field in the load script:

           

          Load

          ProductID,

          ProductgroupID,

          Factorvalue,

          ProductID * Factorvalue as ProdFactVal

          from ....etc;

           

          In a chart you can do the same in an expression: =ProductID * Factorvalue. If the fields are strings you can use the num function to make numbers of them: =num(ProductID) * num(Factorvalue)

          • Re: Conversion factor
            Sunil Chauhan

            use below code

             

            sum(ProductID*Factorvalue)

             

            hope this helps

            • Re: Conversion factor

              Hi

              can anybody help me in this....

               

               

               

              regards,

              baru

                • Re: Conversion factor
                  Stefan Wühl

                  Baru,

                   

                  I think you already got some reasonable answers.

                   

                  If these are not helping you, it would help us to understand if you add some informations. For example, try giving some sample lines of data describing your data model and your expected outcome (like a new field in the data model or a column in a chart (but then please describe also the dimensions you want to use).

                   

                  You can add these informations for example as INLINE tables (QV script snippets using an LOAD * INLINE [.. ] format) or excel tables or at best a small QV .qvw file demonstrating your issue.