topic Create a New Dimension Table?? in QlikView

Create a New Dimension Table??

Tue, 29 Mar 2011 15:52:40 GMT

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

ANDY

Create a New Dimension Table??

deepakk — Tue, 29 Mar 2011 16:15:47 GMT

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.

Create a New Dimension Table??

Wed, 30 Mar 2011 08:20:55 GMT

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.

Create a New Dimension Table??

deepakk — Wed, 30 Mar 2011 10:50:15 GMT

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.