Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
HirisH_V7
Master
Master

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

HirisH
“Aspire to Inspire before we Expire!”
10 Replies
tamilarasu
Champion
Champion

Hi Hirish,

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

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

HirisH_V7
Master
Master
Author

I tried but not working like that,

Thanks for your Reply .

Hirish

HirisH
“Aspire to Inspire before we Expire!”
MK_QSL
MVP
MVP

Change your Final Performance expression as below..

Column(6) * Column(7)

HirisH_V7
Master
Master
Author

Hi  Manish ,

I tried that way too.

Help out with aggr .

Thanks for your response.

HirisH

HirisH
“Aspire to Inspire before we Expire!”
ecolomer
Master II
Master II

Is this ?

p57.png

HirisH_V7
Master
Master
Author

Hi Enrique,

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

Thanks For Your Response,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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

HirisH_V7
Master
Master
Author

Hi,

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

Thanks for your response .

Hirish

HirisH
“Aspire to Inspire before we Expire!”
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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

Nagarjuna