topic Re: Pivot Table Partial Sums in QlikView

Pivot Table Partial Sums

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

Hi All

I need to create three columns as shown below,

Can anyone help me on framing a expression for the third column i.e 'Needed Value' (Highlighted in Yellow)

The calculation logic is explained in the section which is highlighted in red.

Thanks

Koushik

sunny_talwar — Tue, 19 Apr 2016 15:55:42 GMT

May be this:

RangeSum(Sum(Theory), Sum(Practical))/RangeSum(Sum(TOTAL <Name>Theory), Sum(TOTAL <Name>Practical))

Colin-Albert — Tue, 19 Apr 2016 15:57:47 GMT

Can you post an example app so we can see the actual dimension names, field names and expressions you are using.

sunny_talwar — Tue, 19 Apr 2016 15:59:14 GMT

Or may be even this:

Sum(Theory + Practical)/Sum(TOTAL <Name>Theory + Practical)

Anonymous — Tue, 19 Apr 2016 16:18:04 GMT

Thanks for the reply Sunny. Please find the attached QVW.

My actual QVW has additional calculations to be performed.

Can you help me in fixing the expression in QVW.

Please let me know if more information is required.

sunny_talwar — Tue, 19 Apr 2016 16:25:11 GMT

Try this:

=Sum(TOTAL <StudName> Aggr(RangeSum(if(Sum(Theory) < 80 , Sum(Theory)*0.5, Sum(Theory)*0.4),

if(Sum(Practical) < 80 , Sum(Practical)*0.5, Sum(Practical)*0.4)), StudName, Subject))

Anonymous — Wed, 20 Apr 2016 09:06:24 GMT

Thanks Sunny.

Regards

Koushik