Custom Table

Mon, 09 Nov 2015 06:12:17 GMT

I have a scenario where I need to calculate 2 extra field values in a straight table with available other field values, I want to do it in the UI itself I don't need at script level.

problem: I have fields like Scenario, Type, Year, Value. from these fields I want to create a straight table like below , here Medium-to-small rate is the fraction of Mediumvalue/Small value.for Small-to-Large rate formula is Small value/Large Value.

How to create it. please help me on this.

Type	2015 Sep	2014 Sep	2015 Aug	Forecast Stock	Max Stock	2014 Sep	2015 Aug	Forecast Stock	Max Stock
Medium	52840	54992	39753	61295	48613	-3.9%	32.9%	-13.8%	8.7%
Medium-to-small rate	65%	62%	66%	60%	60%	5.9%	-1.6%	9.0%	9.0%
Small	34558	33972	26424	36777	29168	1.7%	30.8%	-6.0%	18.5%
Small-to-Large rate	90%	90%	91%	91%	91%	-0.5%	-1.2%	-1.3%	-1.3%
Large	31040	30672	24012	33468	26543	1.2%	29.3%	-7.3%	16.9%

Please find the sample data in the attachment.

Thanks

John

topic Custom Table in QlikView

Custom Table