
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
new dimension in load script
Hi everyone, I need help with the issue below.
I would like to create a new dimension from another in the load script.
I have a dimension called Accounts (consists of six digits)
Now I need to choose only a few accounts from this dimension and create a new dimension called AcctypeMAa
For example all 521xx1 and all 524xx1 accounts.
So in new dimension will be accounts like 521451, 524781 and so on.
How can i do it in load script?
And what if the dimension was stored as text? How to create?
Thanks for any help.
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if(Wildmatch(account, '521??1', '524??1'), account, null()) as AcctypeMAa
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if(Wildmatch(account, '521??1', '524??1'), account, null()) as AcctypeMAa
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear Rob,
works great.
Thank you very much 🙂
