topic Want to Concatenate the data in QlikView

Want to Concatenate the data

Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I am very new to Qlikview. I have the requirement as below: I want to filter the data coming in excel which is marked in RED for the columns applicable as shown below.

The Aggregated values taken for (Average,Stdev, Average Wt. + (3 * Stdev), Average Wt. - (3 * Stdev) ) should be concatenatedas shown in the Result:

For ex: If I want to take the above Aggregated Calculations for Column StartWt.

	Start Wt
Average Wt.	39.358625
Stdev	0.194965153
+3 Sigma	39.94352046
-3 Sigma	38.77372954

	Data:
		Start Wt	OOI	2nd OOI
		39.53	28.901	28.373
		39.616	29.762	29.016
		39.064	28.075	27.761
		39.116	28.903	28.426
		39.128	28.875	28.284
		39.251	29.135	28.542
		39.373	29.441	28.822
		39.435	29.354	28.713
		39.472	28.42	28.083

	Result:
		Start Wt	OOI	2nd OOI
	Average Wt.	39.358625	28.99888	28.3755
	Stdev	0.194965153	0.551607	0.341234
Average Wt. + (3 * Stdev)	+3 Sigma	39.94352046	30.6537	29.3992
Average Wt. - (3 * Stdev)	-3 Sigma	38.77372954	27.34405	27.3518

Could you please help me in this asap. Please help me sending the answer for this post to harvarinf1531@gmail.com

Re: Want to Concatenate the data

sunny_talwar — Wed, 04 May 2016 16:19:58 GMT

May be like this:

Table:

LOAD * Inline [

Start Wt, OOI, 2nd OOI

39.53, 28.901, 28.373

39.616, 29.762, 29.016

39.064, 28.075, 27.761

39.116, 28.903, 28.426

39.128, 28.875, 28.284

39.251, 29.135, 28.542

39.373, 29.441, 28.822

39.435, 29.354, 28.713

39.472, 28.42, 28.083

];

Concatenate(Table)

LOAD Avg([Start Wt]) + (3*(Stdev([Start Wt]))) as [Start Wt],

Avg([OOI]) + (3*(Stdev([OOI]))) as [OOI],

Avg([2nd OOI]) + (3*(Stdev([2nd OOI]))) as [2nd OOI],

'Average Wt. + (3 * Stdev)' as Flag

Resident Table;

Concatenate(Table)

LOAD Avg([Start Wt]) - (3*(Stdev([Start Wt]))) as [Start Wt],

Avg([OOI]) - (3*(Stdev([OOI]))) as [OOI],

Avg([2nd OOI]) - (3*(Stdev([2nd OOI]))) as [2nd OOI],

'Average Wt. - (3 * Stdev)' as Flag

Resident Table;

Concatenate(Table)

LOAD Avg([Start Wt]) as [Start Wt],

Avg([OOI]) as [OOI],

Avg([2nd OOI]) as [2nd OOI],

'Average Wt.' as Flag

Resident Table;

Concatenate(Table)

LOAD Stdev([Start Wt]) as [Start Wt],

Stdev([OOI]) as [OOI],

Stdev([2nd OOI]) as [2nd OOI],

'Stdev' as Flag

Resident Table;

Re: Want to Concatenate the data

Fri, 06 May 2016 11:46:41 GMT

Thanks Sunny for your quick response. It helped me in time.

Re: Want to Concatenate the data

sunny_talwar — Fri, 06 May 2016 15:48:42 GMT

Awesome, I am glad it did.

Please close this thread if you got what you wanted by marking the correct answer.

Qlik Community Tip: Marking Replies as Correct or Helpful