Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you help me?
Each row has you specific expression to calc.
Tks!!
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!