This content has been marked as final. Show 5 replies
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