topic Pivot table presentation in QlikView

Pivot table presentation

Wed, 25 Nov 2020 16:16:04 GMT

Hi I have a pivot table looks like above dimension is drill down group division and service line. I want the expressions on top and remove the drill down group and show all the data like below:

Division	Service line	Income	Direct Costs	Indirect Costs	Total Direct & Indirect Costs	.	Contribution
Children Service	Children Nursing-SLCCN
	Radiology Direct Access-SLRADDA

Re: Pivot table presentation

MarcoWedel — Mon, 13 Feb 2017 23:00:51 GMT

please post a sample application to demonstrate.

thanks

regards

Marco

Re: Pivot table presentation

Anonymous — Tue, 14 Feb 2017 01:41:50 GMT

Hi azadeh,

I have recently created an income statement in qlikview and i may be able to help you.

If your pivot table is already present in qlikview, i will suggest just drag and drop to swap the column and row dimension.

If you are asking how to come up with expression for income statement i will suggest using interval match function , assuming the revenue items are already positive figures and cost item are negative figures.

refer to this post for more information how to use interval match function How to Create a Profit and Loss Statement in QlikView

If you want the exact expression and script to use, post your qvw and i may be able to help.

Regards,

Re: Pivot table presentation

Tue, 14 Feb 2017 14:15:55 GMT

many thanks , drag and drop to swap the column works for me.

Re: Pivot table presentation

Anonymous — Wed, 15 Feb 2017 02:46:12 GMT

no problem, glad that it works