topic Re: extra Row in Pivot table in QlikView

extra Row in Pivot table

upaliwije — Wed, 03 Aug 2016 07:22:59 GMT

I have following pivot table in my QV document

MONTH	BRAN	CITY	Total
Jan	10,559,260	4,474,770	15,034,030
Feb	10,230,246	3,339,784	13,570,030
Mar	10,901,857	3,112,307	14,014,164
Apr	12,596,211	4,771,915	17,368,126
May	9,078,503	3,868,521	12,947,024
Jun	11,159,057	3,839,047	14,998,104
Total	64,525,134	23,406,344	87,931,478

I want to add Extra rows in the table which is like the table given below

MONTH	BRAN	CITY	Total
Jan	10,559,260	4,474,770	15,034,030
Feb	10,230,246	3,339,784	13,570,030
Mar	10,901,857	3,112,307	14,014,164
Apr	12,596,211	4,771,915	17,368,126
May	9,078,503	3,868,521	12,947,024
TOTAL	53,366,077	19,567,297	72,933,374
Avg. Five Months	10,673,215	3,913,459	14,586,675
Jun	11,159,057	3,839,047	14,998,104
Increase(decrease)	485,842	-74,412	411,429

Is this possible? If so pls help me to do it

Re: extra Row in Pivot table

Gysbert_Wassenaar — Wed, 03 Aug 2016 07:32:02 GMT

You can try this technique: How IntervalMatch Solved My Profit and Loss Dilemma.

Otherwise the answer is No.

Re: extra Row in Pivot table

Anil_Babu_Samineni — Wed, 03 Aug 2016 07:33:28 GMT

Might be this is Not possible

Re: extra Row in Pivot table

marcus_sommer — Wed, 03 Aug 2016 07:34:29 GMT

You need to add these values to your MONTH field (maybe you creates an extra field for these pivot to don't disturb your normal field view and behaviour) with a concatenate load:

concatenate (Calendar)

load * Inline [

MONTH

TOTAL

Avg. Five Months

];

and within the expressions you need to query the value of the MONTH field with an expression like:

pick(match(MONTH, 'TOTAL', 'Avg. Five Months') + 1,

sum(value),

sum(TOTAL value),

avg(aggr(sum(TOTAL value), MonthNum)))

I think you will need some adjustements to the expressions but in general these approach will work

- Marcus

Re: extra Row in Pivot table

upaliwije — Wed, 03 Aug 2016 11:36:19 GMT

Thanks all for your replies helping me. I am working on your suggestions