topic Re: Specific Example of Switch Case statement in QlikView

Specific Example of Switch Case statement

Anonymous — Tue, 02 Jul 2013 12:38:01 GMT

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

Re: Specific Example of Switch Case statement

Tue, 02 Jul 2013 12:42:13 GMT

see link

hope this helps you

http://community.qlik.com/ideas/2563
http://www.qlikblog.at/546/qliktip-20-selectcase-qlikview-loadscripts/

Re: Specific Example of Switch Case statement

swuehl — Tue, 02 Jul 2013 12:42:55 GMT

Maybe like this?

pick(match(PSWHSE,001,003,031)

, TRIM(PSAREA) & TRIM(PSZONE) & LEFT(TRIM(PSAISL,1)) & TRIM(PSBAY)

, TRIM(PSAISL) & TRIM(PSLEVL) & TRIM(PSPOSN)

, TRIM(PSAISL) & TRIM(PSLEVL) & TRIM(PSPOSN) ) AS RESERVELOCATION

within a LOAD.

Re: Specific Example of Switch Case statement

Anonymous — Tue, 02 Jul 2013 12:52:04 GMT

This is exactly what I was looking for. Thank you so much!!!!!! ☺

Re: Specific Example of Switch Case statement

nehasaxena — Mon, 09 Jun 2014 05:27:04 GMT

Is it possible to add Else condition in this expression.

Thanks,

Neha

Re: Re: Specific Example of Switch Case statement

anbu1984 — Mon, 09 Jun 2014 05:57:17 GMT

Try this

pick(match(PSWHSE,001,003,031)+1

, else_expression

, TRIM(PSAREA) & TRIM(PSZONE) & LEFT(TRIM(PSAISL,1)) & TRIM(PSBAY)

, TRIM(PSAISL) & TRIM(PSLEVL) & TRIM(PSPOSN)

)