Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
satishkurra
Specialist II
Specialist II

Expression Help

Hi

I have the below pivot table data with Country, Service Lines and Sales%

   

Country 12345678910111213141516171819
A 40.0%12.0%6.0%1.0%-5.0%12.0%5.0%-1.0%6.0%13.0%-40.0%35.0%145.0%9.5%11.1%-18.0%245.2%16.3%-69.5%
B 1.0%1.0%3.0%56.0%45.0%23.0%8.0%10.0%6.0%56.0%34.0%-10.0%-20.0%-30.0%37.4%90.0%8.0%6.0%-70.0%

I need to show Increase Icon for highest % and nothing for other %

For example, for country A, highest % is 145% which should show icon and the rest all values for Country A should be blank.

I understand that we can do a custom format cells, but the value 145% is not constant and once data changes the highest % may go to other service line.

Request to please help on the same.

Thanks

Satish

11 Replies
sunny_talwar

I think you might be using number fromatting from numbers tab, change that to expression default and use num function to format the max value in % format

satishkurra
Specialist II
Specialist II
Author

Thanks Sunny, It worked...