I am beginner to Qlikview, I have requirement. I have loaded the Sales Data from ODBC the Table Name is [SALES], One field Salesmantype Derived with Case Statement When empddress as Salesmantype.
Now my requirement is, from the same table [SALES] I have Sales man code(SLMCODE), I have to check SLMCODE='AAA' then I have to change the value of Salesmantype ='ZZZ' like that I have to check for 5 SLMCODE's. How to achieve, plz explain with same example.
In my solution i have aliased the field e.[empaddr2] to Salesmantype_old. I have then performed extra transformation to the field Salesmantype_old inside the preceding LOAD and renamed it back to Salesmantype.
The last drop statement was just to remove the field Salesmantype_old. You will still have field Salesmantype at the end.
If you are confused, you can even remove the drop statement for field Salesmantype_old and it should still work.
