2 Replies Latest reply: Jun 22, 2012 7:39 AM by sm123abc RSS

    Adding to existing expression

      Hi Everyone

       

      I'm new to Qlikview and I'm having trouble with an expression.
      I don't have access to change script, but create charts and tables from data generated by a SAP system to show on a webview.
      My problem is I'm trying to add to an existing expression with no luck.

       

      if(Len(KNVP_ADD.PERNR_NAME) ->,'-',KNVP_ADD.PERNR_NAME)

       

      This is an expression that I was given when I found that the field name KNVP_ADD.PERNR_NAME can in some cases have several name entries behind it.
      Causing records in my tables to duplicate.


      The expression  allows only single entries to be shown and when there are more than one it shows null (and it works).

      But I have to add   OrderEntry.VBAK.AUART -= {'ZCOM','ZRER','KA','KB'} to the expression.


      This field name covers document types, so I don't want to show these document types in my tables.

      Any help in accomplishing this would be very welcome.


      Thanks Sean

        • Re: Adding to existing expression

          Hi Sean,

           

          You can use Replace() function to remove document types.

           

          Thanks

          Supriya

            • Re: Adding to existing expression

              Hi Supriya

               

              Thanks for replying and sorry I've taken so long to answer.

              I've tried using replace as above and it does remove the document types, but then the other part of the expression 

              if(Len(KNVP_ADD.PERNR_NAME) ->,'-',KNVP_ADD.PERNR_NAME) doesn't work now no entries are returned at all.

               

              This is the expression I've tried to use it removes the document types, but doesn't show the entries correctly like the original expression did. The edit expression box shows expression OK and I've tried variations on the expression.

               

              =Replace((OrderEntry.VBAK.AUART =-'ZCOM','ZRER','KA','KB'),if(Len(KNVP_ADD.PERNR_NAME) ->,'-', KNVP_ADD.PERNR_NAME))

               

              What could be wrong with the expression I want to remove the documents while still having the second part working as it did originally.

               

              Thanks in advance for your help

               

              Sean