Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Pivot Table, rows colored depending on the data in the row?

Hi all,

I have a pivot table in Qlik Sense of months as columns, with data for each value in my rows. I want to grade each row with a color gradient dependent on the rank of values in the cells.

For example for a row, if January has value 1, and December has value 12 (with steps of 1 increasing), I'd like to have a color gradient across these cells, with the largest being opposite to the smallest value in color.

I've tried some solutions in the formula bar for the color of my data but no luck.

Any help would be greatly appreciated.

Cheers


Nick

chrome_2018-01-11_13-55-46.png

4 Replies
Highlighted
Partner
Partner

do u have QlikView installed?

Highlighted
Contributor III
Contributor III

No, just Qlik Sense

Highlighted
Partner
Partner

First try, color by measure and see if it suits you

Capture.PNG

Highlighted
Contributor III
Contributor III

Hi ,

Unfortunately I don't have access to this panel, I have (see attached)

Thanks

chrome_2018-01-11_15-49-29.png