Gradient color on pivot table based on each row

[kira_whopper]

Hi there,

I'd like to format a gradient background color on a pivot table considering each row separately. For exemple, my goal is to show higher values in red, middle values in yellow and lower values in green, but those values are to be considered for each row separately (taking into account that a row here is assembled by the dimension "Assingment Group" and the Dates).

The final result for each row, using excel, would be this:

This is the expression on the pivot table:

Count(DISTINCT {<Task_Source = {'Incidents'}, Task_SourceType = {'Opened'}, Task_RefDate= {">=$(=Date(Max(Task_RefDate)-15))"}>} Task_Number)

Attached is a sample.

Thanks in advance

[antoniodneto]

Can you help me?

Each row has you specific expression to calc.

Tks!!

[JRamos]

Hi!

I'm trying to do something similar. but not per row just using all the table data, but I can't, needs to be similar to my old tableau table, my measure is: count(distinct([Unique Value])).

The max number is the red one and min number should be gray

Old tableau table

New pivot table in QlikSense

Can you guide me, thanks in advance!