2 Replies Latest reply: Dec 22, 2015 3:04 PM by Massimo Grossi RSS

    Need help!

      I have survey response for more than 100 questions like

      No Knowledge/Experience

      Beginner

      Applying

      Leading

      Expert


      I want to predefine them as number like 1 -5. So each time when load a file (Responses are in different  file) it should automatically consider the response as numbers. Is there a way in qlikview to do that . please help.

        • Re: Need help!
          Sunny Talwar

          May be create a Mapping Table:

           

          MappingTable:

          Mapping

          LOAD * Inline [

          Response, NumResponse

          No Knowledge/Experience, 1

          Beginner, 2

          Applying, 3

          Leading, 4

          Expert, 5

          ];


          FactTable:

          LOAD Responses,

                    ApplyMap('MappingTable', Responses) as Numbered_Response

          From Source;

          • Re: Need help!
            Massimo Grossi

            another could be

             

            load Response, AutoNumber(Response) as ResponseId inline [

            Response

            No Knowledge/Experience

            Beginner

            Applying

            Leading

            Expert

            ];

             

            load

              AutoNumber(Response) as ResponseId,

              ......     // other fields

            From YourFile;