Addition

[Nikhil2725]

Hi Team,

I have a below table.

PH6	PH6_desc	Sales T/O
231546	BV 546	1163729
255373	VAG Produkte	1092099
221051	El. fusion fitti. PB	880487
201950	Solv.cement fitt.me.	874874
230152	Solv. Cement Fit. mm	689215
202956	Ballvalves for water	550592
230153	Adapter Fittings mm	531082
251313	ELGEF Plus saddles	464251
221043	Pipe PB in bars	451753
2J1J54	Regulierarmaturen	432843

Further I want to add new column as below. Kindly help me in doing this.

PH6	PH6_desc	Sales T/O	New Column	Description
231546	BV 546	1163729	1163729	For the first row the value should be same as Sales T/O(1163729)
255373	VAG Produkte	1092099	2255828	Addition of 1st row and 2nd row of Sales T/O(1163729+1092099)
221051	El. fusion fitti. PB	880487	3136315	880487+2255828
201950	Solv.cement fitt.me.	874874	4011189	874874+3136315
230152	Solv. Cement Fit. mm	689215	4700404	689215+4011189
202956	Ballvalves for water	550592	5250996	550592+4700404
230153	Adapter Fittings mm	531082	5782078	531082+5250996
251313	ELGEF Plus saddles	464251	6246329	464251+5782078
221043	Pipe PB in bars	451753	6698082	451753+6246329
2J1J54	Regulierarmaturen	432843	7130925	432843+6698082

[Kushal_Chawda]

Please share the actual sample data

[Nikhil2725]

This is the sample data..

PH-6	PH-6 name	Sales T/O	Cumulative T/O
231546	BV 546	1,163,729	1,163,729
255373	VAG Produkte	1,092,099	2,255,828
221051	El. fusion fitti. PB	880,487	3,136,315
201950	Solv.cement fitt.me.	874,874	4,011,189
230152	Solv. Cement Fit. mm	689,215	4,700,404
202956	Ballvalves for water	550,592	5,250,996
230153	Adapter Fittings mm	531,082	5,782,077
251313	ELGEF Plus saddles	464,251	6,246,328
221043	Pipe PB in bars	451,753	6,698,081
2J1J54	Regulierarmaturen	432,843	7,130,924
251301	PE Spigot Fittings	393,140	7,524,064
229641	Containit Pipe	290,104	7,814,168
251314	ELGEF Plus fittings	248,483	8,062,651
281557	customizing	245,209	8,307,860
231161	Contr.+ Check Valves	240,762	8,548,623
234539	KH 546 PP	224,185	8,772,807
251312	ELGEF Plus couplers	216,383	8,989,190
230162	Accessories	210,783	9,199,973
234180	Adapter Fittings mm	176,652	9,376,625
339695	ele.act.ballvalve546	171,343	9,547,969
201951	adap.fitt.pipe M/Gas	171,334	9,719,303
221050	Socket fusion fi. PB	161,197	9,880,500
231158	Diaphragm Valves	160,305	10,040,805
235188	SYGEF pipes	148,664	10,189,469
251303	PE Saddles	146,660	10,336,129
231567	BV 567 PVC Wafer	142,301	10,478,430
339212	Diaphragm Valves	142,195	10,620,625
281554	Ventilation	140,034	10,760,660
339696	pne.act.ballvalve546	139,972	10,900,632
348227	Variable Area Flow M	138,327	11,038,958
235540	KH 546 PVDF	133,307	11,172,265
234238	Flanges	123,581	11,295,846
231149	Ball Valves 353-355	123,476	11,419,323
339772	MV DIASTAR	116,451	11,535,774
228473	Tangit	110,817	11,646,592
232450	Fittings CPVC	109,420	11,756,011
263405	Fittings NEW	105,797	11,861,808
221039	pipes d125-225	102,025	11,963,833
235190	Butt Weld Fittings	99,495	12,063,328
234403	Butt fusion ad.unio.	96,595	12,159,922
340220	Sensors	93,868	12,253,790
127140	PRIMOFIT end load	92,262	12,346,052
235191	Adapter Fittings	91,163	12,437,215
358458	Products by Frank	89,011	12,526,226
234179	Butt Weld Fitting mm	87,868	12,614,094
237202	Pipes	85,954	12,700,049
237773	PVDFHP MV man	78,989	12,779,038
231001	BV 543 PVC	77,636	12,856,674
230163	Flanges PVC	76,700	12,933,374
154323	Couplings standard	73,957	13,007,331
221061	Valve PB	72,306	13,079,636
280177	Pipes PP	72,178	13,151,814
339643	Ele.actu. b.valve567	70,133	13,221,947
234637	BV 567 PP-H  Wafer	69,749	13,291,696
265435	Diaphragm Valve	67,659	13,359,355
268241	Butt ada.fitting ISO	67,218	13,426,573
339215	Solenoid valves	63,427	13,490,000
280244	Pipes PE100	61,885	13,551,885
231780	PVCU MV man	58,243	13,610,128
268240	Butt weld fitting mm	57,135	13,667,263
221045	Carrier for pipe	55,967	13,723,230
231156	Ballval. 322-324,343	54,289	13,777,519
232541	KH 546 C-PVC	53,613	13,831,132
234178	Socket Weld Fitt. mm	49,917	13,881,049
339644	Pne.act. b.valve 567	48,334	13,929,383
230166	Adapter Fittings BS	48,125	13,977,507
251306	Electrofusion Units	47,905	14,025,413
237249	Butt Weld Fitting	46,564	14,071,977
237230	Unions	45,057	14,117,033
280449	Pipes PVC-C	44,848	14,161,881
243770	Machine IR 110 sales	42,355	14,204,236
268332	PEadapter fittingsMS	39,214	14,243,451
346251	Ele. Rotary Actuator	38,523	14,281,974
226078	PP HT-Syst.FittingIT	33,959	14,315,933
340333	Transmitter	33,341	14,349,274
221600	Butt fusi. d125-d225	32,589	14,381,863
268265	Socket Weld Fittings	32,220	14,414,083
234182	Diaphragm Valves	31,906	14,445,989
235421	Butt fusion ada. un.	31,263	14,477,252
235189	Socket Weld Fittings	30,994	14,508,246
234184	Contr.+ Check Valves	30,710	14,538,956
231798	ac.gen.5ind.of subd.	30,278	14,569,234
226077	PP HT-System PipesIT	29,480	14,598,713
251305	Tools/Inst. Acc.	28,947	14,627,661
233372	Cool-Fit	27,590	14,655,250
202958	Ball valves for irr.	27,405	14,682,655
228495	Loctite	26,135	14,708,790
235774	PVDF DV514,515,517,519	26,087	14,734,877
339216	Electric posit. ind.	25,958	14,760,835
344232	Sensors	25,461	14,786,296
235784	SYGEF Exhaust System	25,101	14,811,396
215080	Electr. control unit	25,100	14,836,496
346248	Pilot Solenoid Valve	24,528	14,861,024
999999	Dummy non-prod.	24,429	14,885,453
237206	Diaphragm Valve	24,045	14,909,499
344334	Transmitter	23,541	14,933,040
339214	Angle Seat Valves	22,611	14,955,651
231160	Angle Seat Valves	22,073	14,977,723
237423	Butt fusion ada. un.	20,501	14,998,225
235193	Diaphragm Valve Hand	20,055	15,018,280
231155	Ball Valves 346	18,732	15,037,012
233197	Socket Fitti. mm ABS	18,652	15,055,664

[Kushal_Chawda]

In your Table just sort the column you want to sort. For other column remove all the sort option (like for PH6,PH_desc) then I think original expression without aggr sorting option should work

[Nikhil2725]

Hi, 

The above table is the combination of 2 to 3 tables and what ever i showed that is the final output i require..

[Kushal_Chawda]

I am asking to sort the field in front end chart and not in backend.

In chart properties->Sorting-> Sort only Sum(Sales T/0) expression. For rest uncheck all sort option

[Nikhil2725]

I tried, but no luck its not sorting

[Kushal_Chawda]

please share your qvf file

[Nikhil2725]

Please find the attached file

[Nikhil2725]

Hi Kush,

Thanks for the support, however we cannot derive the output as I needed.

Please go through the link below.

https://community.qlik.com/t5/Qlik-Sense-App-Development/Table-will-not-sort-with-RangeSum/m-p/10249...

[Kushal_Chawda]

Yes. I got that.  See the attached. with some tricks you can do that