Dimension Query

[snarrp_Rocky]

Dear All, Need your help on below query. I have two dimensions in the data, I need to get them in one dimension in qlik view. The output shown below. Your help is great appreciated. Regards

Data

Dimension1         Dimension2     Sales

Parent                                                   1000

                                         Child1            230

                                        Child2            234

                                         Child3           450

Qlik view output should be

Dimension Sales

Parent 1000

Child1 230

Child2 234

Child3 450

Note: I do not want to use IF function here since that slows down the calculation speed.

[venkat1]

hi 

https://community.qlik.com/t5/QlikView-App-Development/Combining-values-from-multiple-dimensions-in-... 

may be this will help you .

[VishalWaghole]

Hi

Use below if statement while loading data,

If(isNull(Dimensions1), Dimensions2, Dimensions 1) as Dimensions

Thanks and Regards,
Vishal Waghole

[snarrp_Rocky]

Thanks for this Venkatesh. Actually I did not give the clear data structure. Please find below the data and the output I am trying to achieve. Your help is much appreciated.

Data
Dimension1	Dimension2	Sales
Parent		1000
	Child1	230
	Child2	240
	Child3	320
	Child4	457
	Child5	84
	Child6	544
	Child7	141

Output
Dimension	Sales
Parent	1000
Child1	230
Child2	240
Child3	320
Child4	457
Child5	84
Child6	544
Child7	141

[VishalWaghole]

Hi

Try this,

Data:
Load Dimension1 as Dimension,
Sales
From YourTable
Where not isNull(Dimension1);

Concatenate (Data)
Load Dimension2 as Dimension,
Sales
From YourTable
Where not isNull(Dimension2);

Thanks and Regards,
Vishal Waghole

[VishalWaghole]

If above solution not worked then try this

Data:
Load Dimension1 as Dimension,
Sales
From YourTable
Where len(Dimension1)>0;

Concatenate (Data)
Load Dimension2 as Dimension,
Sales
From YourTable
Where len(Dimension2)>0;

Hope this will work for you.

Thanks,
Vishal

[snarrp_Rocky]

Thanks Vishal. But Can this be done with expression which should not lead to performance issue? Usually IF function is good for this but IF function slows down the performance. I have huge records in the QVD.

Solution with Expression would be very helpful please.

[PrashantSangle]

try alt() also, If your column1 contain null records and you want to replace with column2 then use
alt(column1,column2) as new_column

Regards,