I understand that QlikView does not like MS SQL CASE statements so I am trying to work around this. It will get more complex but I have to start getting away from the SQL way for this. I basically want to do a select like this:
SLELECT something1, something2, ...., UseRate =CASEWHEN[UKURS]= 0 THEN 1
This will turn all 0s to 1s....what I really want to do next is look up, in another table, an actual rate based on a different field, like a subselect.... SELECT Rate from rateTable WHERE Country = 'UK' AND Month = 4 and Year = 2015.....but I must learn to walk before I can run....
Sorry Vikas, maybe I am not clear or I misunderstand you. Can I use a CASE in SQL in QlikView...it appears to throw an error when it hits a case in a sql block...my code works perfectly in SQL Management Studio but dies when I bring it into QlikView.
Must have meen a typing mistake as it does work and the article that stated that "CASE" does not work when loading tables, actually refers to using a CASE statement in a LOAD not SQL created tables. This is good news for me. Thanks for the responses.