5 Replies Latest reply: Jun 9, 2014 1:57 AM by anbu cheliyan RSS

    Specific Example of Switch Case statement

    Robert Fishel

      Hello my friends.  I have had no luck so far in finding a specific working example of a SWITCH CASE statement as used in QlikView.  I have added my original sample code below.  Will someone please kindly re-write and then explain how this code would look and work as a SWITCH CASE statement.  Thank you.

       

                CASE
                      WHEN PSWHSE = 001 THEN TRIM(PSAREA) || TRIM(PSZONE) || LEFT(TRIM(PSAISL,1)) || TRIM(PSBAY)
                      WHEN PSWHSE = 003 THEN TRIM(PSAISL) || TRIM(PSLEVL) || TRIM(PSPOSN)
                      WHEN PSWHSE = 031 THEN TRIM(PSAISL) || TRIM(PSLEVL) || TRIM(PSPOSN)
                 END
                 AS RESERVELOCATION