Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nathan_lin
Contributor II
Contributor II

Pivot Table: Color code

Hi everyone,

I am trying to color code my pivot table. The value are ranging from -1 to 1. i try to make the data above 0 in Green and below 0 in red. And the same time, the color is also value associated.

the current expression i use is:

ColorMix2(Sum({$<country_cde={"us"}>}[pivot_data.value])/before(Sum({$<country_cde={"us"}>}[pivot_data.value]))-1,RGB(128,0,0),rgb(0,100,0))

but the color is showed is below: Screen Shot 2018-01-24 at 1.28.31 PM.png

any suggestion?'

Thanks,

Nathan

2 Replies
petter
MVP
MVP

Do you have a sample app or sample data we could tweak - so you get some suggestions quicker?

nathan_lin
Contributor II
Contributor II
Author

  ... no .. and i could not share the original data. sorry about that.