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: 
muniyandi
Creator III
Creator III

Max value color change in pivot table

Hi,

How to Change max rate color in pivot chart.. rate get from avg(rate).

With Regards,

Muni.

1 Solution

Accepted Solutions
daveamz
Partner - Creator III
Partner - Creator III

Then change expresion to:

if(avg(rate)=max(total <City,[Item Name]> rate),rgb(0,0,255),'')

and you will get:

Untitled.jpg

Regards,

David

View solution in original post

6 Replies
daveamz
Partner - Creator III
Partner - Creator III

Hi,

     Try this:

Untitled.jpg

Dave

muniyandi
Creator III
Creator III
Author

Hi  daveamz01,

this expression working,But different city,item,customer added. this expression not working.

With Regards,

Muni.

daveamz
Partner - Creator III
Partner - Creator III

Then change expresion to:

if(avg(rate)=max(total <City,[Item Name]> rate),rgb(0,0,255),'')

and you will get:

Untitled.jpg

Regards,

David

muniyandi
Creator III
Creator III
Author

Thanks Dave,

it's working. in am new to qlikview. what is mean by < City,[Item Name] >

Muni

daveamz
Partner - Creator III
Partner - Creator III

You can have different max values depends on what you what to relate on: eg. max(rate) for all values is 83, for each item is 33 for M 1 KG and 88 for M 1 5 KG.

Same for sum, avg expressions.

See the file attached.

muniyandi
Creator III
Creator III
Author

Thanks Dave.