Make new field with Qlikview

[#1]

Helo, I have a db that contains regions, groups and clusters. The thing I want is to "make a new region" with Qlikview.

If a group has the number 60301 than I want Qlikview to make a region called "newregion" (this region does not exist in my database). I've tried the folowing but it does not work because I now have to fields the same name in the same database.

LOAD
if (Group='60301','newregion',Group) as Region,
Cluster,
Region,
Name

from....

Can anyone help me with this?

[#2 · Accepted solution]

If I understand you correctly you want to do this:

Load
if(Group='60301','newregion',Region) as Region,
Cluster,
Name
from....

/Fredrik

[#3]

thx it works !