topic Re: Dimension Query in QlikView

Dimension Query

snarrp_Rocky — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Dimension Query

venkat1 — Sat, 30 Mar 2019 12:00:02 GMT

https://community.qlik.com/t5/QlikView-App-Development/Combining-values-from-multiple-dimensions-in-one-axis/m-p/1021595

may be this will help you .

Re: Dimension Query

VishalWaghole — Sat, 30 Mar 2019 19:48:59 GMT

Hi

Use below if statement while loading data,

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

Thanks and Regards,
Vishal Waghole

Re: Dimension Query

snarrp_Rocky — Wed, 03 Apr 2019 06:57:16 GMT

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

Re: Dimension Query

VishalWaghole — Wed, 03 Apr 2019 08:33:55 GMT

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

Re: Dimension Query

VishalWaghole — Wed, 03 Apr 2019 11:43:15 GMT

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

Re: Dimension Query

snarrp_Rocky — Thu, 11 Apr 2019 10:17:14 GMT

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.

Re: Dimension Query

PrashantSangle — Thu, 11 Apr 2019 10:39:11 GMT

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,