Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a New Dimension Table??

Hello Experts,

I was wondering how can I create a New Dimension table using some of the available customer dimensions. I have 2 levels of customers, I want to Pick level 1 and some from Level 2 and then Join them as a New dimension to use in the creation of some complex charts. How can I do that? Please check the attachment for more info and I am ready to provide more details if required.

Thanks Again

ANDYerror loading image

3 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi,

Try this for a soln.

if(wildmatch(Hierarchy 2,'John*') >0, 'John Group', if(wildmatch(Hierarchy 2,'Terry*') >0, 'Terry Group' and so on...

I hope this helps.

Not applicable
Author

Hello Deepak,

I am looking for something at the script level like If(Hierarchy1 = 'John' and Hierarchy2= 'John1', 'John2') Load as John Group. This way I am selecting some John 2 Hierarchy customers and not all and forming a different Dimension. Like John I have about 40 customers from Hierarchy1 and 100 from Hierarchy 2. I was looking something like the Valuelist function used in the charts to calculate this, which can replace the huge expressions in the chart with something at the script level as this groups are fixed and dont change at all.

deepakk
Partner - Specialist III
Partner - Specialist III

hi,

I have mention the above code for the script.

One reloaded you will have a new field say X. and it will contain John Group , Terry Group.

When you select Jhon Group from this field you will be see respective Jhon1 , jhon2 from other field .

I didnt get you last comments, I hope what i sugggested helps you out.