Front end

rkspareek1992 — Sat, 06 Oct 2018 08:44:08 GMT

Hi,

I have big tables data with have many dimensions (as Dim1, Dim2, Dim3....) and have many columns of quantity and amount columns.

Format is as below:

Dim1	Dim2	Dim3	Quantity	Amount
Battery	Import	1001	10	100
RML	Import	1001	20	200
Radio	Import	1001	30	300
Battery	Domestic	1001	40	333
RML	Domestic	1001	5	444
Radio	Domestic	1001	7	222
Battery	Import	1002	8	111
RML	Import	1002	9	654
Radio	Import	1002	11	78
Battery	Domestic	1002	10	54
RML	Domestic	1002	55	32
Radio	Domestic	1002	44	45

Now I wants to show the data in below mentioned form:

Dim	Sum of Actual	formula (only for understanding)
Battery Quantity	68	sum of Qty
Battery Quantity (Domestic)	50	sum of Qty
Battery Quantity (Import)	18	sum of Qty
RML Quantity	89	sum of Qty
RML Quantity (Domestic)	60	sum of Qty
RML Quantity (Import)	29	sum of Qty
Radio Quantity	92	sum of Qty
Radio Quantity (Domestic)	41	sum of Qty
Radio Quantity (Import)	51	sum of Qty
Battery Rate (Domestic)	7.74	Sum of Amount/Sum of Qty
Battery Rate (Import)	11.72	Sum of Amount/Sum of Qty

Kindly suggest how to get this format in qlikview.

I cannot use crosstable or any other table formation methods because data is too big. Wanna changes in front end with the help of mapping from excel or through expression.

Re: Front end

Sebastian_Fredenberg — Mon, 08 Oct 2018 06:50:39 GMT

Hello,

I suggest you post that question in for example QlikView App Development‌.

(It's not related to scalability/performance)

Regards

Sebastian

topic Re: Front end in Scalability

Front end

Re: Front end