Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
If I understand you correctly you want to do this:
Load
if(Group='60301','newregion',Region) as Region,
Cluster,
Name
from....
/Fredrik
If I understand you correctly you want to do this:
Load
if(Group='60301','newregion',Region) as Region,
Cluster,
Name
from....
/Fredrik
thx it works !