3 Replies Latest reply: Jun 5, 2015 8:07 AM by Andrew Whitfield RSS

    Urgent Advice

      Hi,

       

      I am very new to Qlikview and I was hoping somebody can help me with a query and let me know if what I want to do is even possible.

       

      I have names with ID's(Names,ID) corresponding to each name. On the second data sheet the ID's (ID1) are only available but I need to be able to show the correlation name to the ID.

       

      The file is attached below if anybody could give me some advice.

       

      Thanks.

        • Re: Urgent Advice
          Ramon Covarrubias

          I would suggest you doing this in the backend

           

          use applymap

           

          The ApplyMap function is used for mapping any expression to a previously loaded mapping table. The syntax is:

          applymap('mapname', expr [ , defaultexpr ] )

          where:

          mapname is the name of a mapping table that has previously been created through the mapping load or the mapping select statement (see Mapping). Its name must be enclosed by single, straight Quotation Marks in Scripting.

          expr is the expression, the result of which should be mapped.

          defaultexpr is an optional expression which will be used as a default mapping value if the mapping table does not contain a matching value for expr. If no default value is given, the value of expr will be returned as is.

          Examples:

          // Assume the following mapping table:

          map1:

          mapping load * inline [

          x, y

          1, one

          2, two

          3, three ] ;

           

          ApplyMap ('map1', 2 ) returns ' two'

          ApplyMap ('map1', 4 ) returns 4

          ApplyMap ('map1', 5, 'xxx') returns 'xxx'

          ApplyMap ('map1', 1, 'xxx') returns 'one'

          ApplyMap ('map1', 5, null( ) ) returns NULL

          ApplyMap ('map1', 3, null( ) ) returns 'three'

          • Re: Urgent Advice
            m w

            Make table box and include ID, Name, and Name1.

            • Re: Urgent Advice
              Andrew Whitfield

              Hi Sue,

               

              do you mean like this?

               

               

              Andy