Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

hirishv7
Honored Contributor

Final Total In Pivot

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.

Pivot Fperf.PNG

PFA,

Thanks in advance,

Hirish

“Aspire to Inspire before we Expire!”
Tags (2)
10 Replies

Re: Final Total In Pivot

Hi Hirish,

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

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

hirishv7
Honored Contributor

Re: Final Total In Pivot

I tried but not working like that,

Thanks for your Reply .

Hirish

“Aspire to Inspire before we Expire!”
MVP
MVP

Re: Final Total In Pivot

Change your Final Performance expression as below..

Column(6) * Column(7)

hirishv7
Honored Contributor

Re: Final Total In Pivot

Hi  Manish ,

I tried that way too.

Help out with aggr .

Thanks for your response.

HirisH

“Aspire to Inspire before we Expire!”
ecolomer
Honored Contributor II

Re: Final Total In Pivot

Is this ?

p57.png

hirishv7
Honored Contributor

Re: Final Total In Pivot

Hi Enrique,

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

Thanks For Your Response,

Hirish

“Aspire to Inspire before we Expire!”
nagarjuna_kotha
Valued Contributor II

Re: Final Total In Pivot

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

Pivot.PNG

Regards,

Ngarjuna

hirishv7
Honored Contributor

Re: Final Total In Pivot

Hi,

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

Thanks for your response .

Hirish

“Aspire to Inspire before we Expire!”
nagarjuna_kotha
Valued Contributor II

Re: Final Total In Pivot

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

Nagarjuna