Max value color change in pivot table

[muniyandi]

Hi,

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

With Regards,

Muni.

[daveamz]

Hi,

     Try this:

Dave

[muniyandi]

Hi  daveamz01,

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

With Regards,

Muni.

[daveamz · Accepted solution]

Then change expresion to:

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

and you will get:

Regards,

David

[muniyandi]

Thanks Dave,

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

Muni

[daveamz]

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]

Thanks Dave.