topic Final Total In Pivot in QlikView

Final Total In Pivot

HirisH_V7 — Sat, 21 Nov 2015 08:03:53 GMT

Hi all,

Here in the Attached Pivot table ,

I required to calucualte Final Performance Line,

It should be , at

Dimensionality=1,

CLP * Performace

Dimesionality =0,

Total of that above line .

But,when i select each states it should give relative individual Percentages.

PFA,

Thanks in advance,

Hirish

Re: Final Total In Pivot

tamilarasu — Sat, 21 Nov 2015 08:40:29 GMT

Hi Hirish,

I cant open your qvw now. Not sure but just try.

sum(TOTAL (<CLP> * <Performance>))

Re: Final Total In Pivot

HirisH_V7 — Sat, 21 Nov 2015 08:50:20 GMT

I tried but not working like that,

Thanks for your Reply .

Hirish

Re: Final Total In Pivot

MK_QSL — Sat, 21 Nov 2015 08:59:47 GMT

Change your Final Performance expression as below..

Column(6) * Column(7)

Re: Final Total In Pivot

HirisH_V7 — Sat, 21 Nov 2015 09:10:35 GMT

Hi Manish ,

I tried that way too.

Help out with aggr .

Thanks for your response.

HirisH

Re: Final Total In Pivot

ecolomer — Sat, 21 Nov 2015 09:45:18 GMT

Is this ?

Re: Final Total In Pivot

HirisH_V7 — Sat, 21 Nov 2015 10:03:52 GMT

Hi Enrique,

Total for that line also to be displayed . Like Screen shot.

Thanks For Your Response,

Hirish

Re: Final Total In Pivot

nagarjuna_kotha — Sat, 21 Nov 2015 11:51:18 GMT

Hi i worked around your file and sharing this file. IN that file For Jan its not showing total becoz clp have total and perfomance dont have total as per our expression its multiplying so its giving null.For Feb its giving.

Plz go through it and let me know

Regards,

Ngarjuna

Re: Final Total In Pivot

HirisH_V7 — Sat, 21 Nov 2015 11:56:35 GMT

Hi,

i want to display final total for the Final performance itself . as per the screen shot .

Thanks for your response .

Hirish

Re: Final Total In Pivot

nagarjuna_kotha — Sat, 21 Nov 2015 12:09:44 GMT

In my above reply its showing for Feb, For Jan Becoz null in Performance its not showing

Nagarjuna

Re: Final Total In Pivot

HirisH_V7 — Sat, 21 Nov 2015 12:24:28 GMT

Actually ,

I m not concern about the main total for performance .

final performance line summation required.