topic Re: Pivot table in sub total in QlikView

Pivot table in sub total

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Expert

I have attached my qvw file in my second expression (sellout %) in bottom total it is showing this sum of percentage value

	Sellout			Sellout %
Total	8,625	5,438	14,062	2,376%	1,624%	4,000%

But it has show like this in sub total. please help us how to fix it something like 8625/14062, 5438/14062

	Sellout			Sellout %
Total	8,625	5,438	14,062	61%	39%	100%

Re: Pivot table in sub total

sunny_talwar — Tue, 04 Oct 2016 15:04:53 GMT

Try this expression:

Sum(Sell_NDPCurrMth)/Sum(TOTAL <[Product Line]> Sell_NDPCurrMth)

Re: Pivot table in sub total

trdandamudi — Tue, 04 Oct 2016 15:22:00 GMT

May be as below for sellout% expression:

Sum(Sell_NDPCurrMth)/Sum(TOTAL Sell_NDPCurrMth)

Re: Pivot table in sub total

Anonymous — Wed, 05 Oct 2016 06:34:30 GMT

Hi Sunny

There is any other way get it by using column "Sell_NDPCurrMthPercent". I have to use only this column for calculate % not Sell_NDPCurrMth. Just mentioned the sample to data. that % column calcaulted in DB on many business logic

Re: Pivot table in sub total

nagarjuna_kotha — Wed, 05 Oct 2016 06:51:04 GMT

Try this

I hope this may helps you.

-Nagarjun

Re: Pivot table in sub total

sunny_talwar — Wed, 05 Oct 2016 10:17:31 GMT

This is the best you can do:

If(Dimensionality() = 0, Sum(Sell_NDPCurrMth)/Sum(TOTAL <[Product Line]> Sell_NDPCurrMth),

Sum(Sell_NDPCurrMthPercent))