Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Find Maximum value in individual row in pivot table

Hello,

can any one have idea that how to find Maximum value in individual row in pivot table excluding total value at the end?

Same for Maximum value from entire pivot table excluding total value row and column which is last row and last column.

Thanks

Dipak

1 Solution

Accepted Solutions
Not applicable
Author

calculate max value for each dimenison in script & compare with that value in the chart

View solution in original post

9 Replies
Not applicable
Author

Hi,

Can u post ur pivot table here ?

Regards

fdelacal
Specialist
Specialist

You are looking something like this??

see atach

Not applicable
Author

Basically i want to change the background color of the maximum value in row and maximum value in pivot table.

Not applicable
Author

How many dimenisons u have in ur pivot table ?

Could you post the excel export ?

Regards

Not applicable
Author

Thanks for reply.

Please find attached xls file.

Here you can see that i want to hightlight all the cells which have maximum value in row.

Thanks

Dipak

ester_pr
Partner - Creator
Partner - Creator

Hi,

I am having the same problem

did you find the answer

?

Thanks,

Ester

ester_pr
Partner - Creator
Partner - Creator

Hi,

I am having the same problem

did you find the answer

?

Thanks,

Ester

Not applicable
Author

calculate max value for each dimenison in script & compare with that value in the chart

ester_pr
Partner - Creator
Partner - Creator

I thought there was a simpler way,
Thanks for the reply,

Ester