Conditional show and colour in qliksense pivot table
I have one requirement where i want to color the Date field based on Component_Status field for each component when Date is equal to today's date. Since todays date is 25 Feb so it should color the rows of 2/25/2021 for each component based on Component_Status field.
Also it should show when each Component is reaching Component_ECD(by marking the cell with 1).
with above expression it is working fine, one thing which i forgot in the requirement is the color should also roll up in the Totals cell, each color has assigned with one priority(Green=3, Yellow=2, Red=1), Totals cell color will be minimum of the Component's color present i.e in above case all 3 colors are present so Totals cell color should be Red (based on minimum priority Criteria), likewise for other colors combination.
Unfortunately, coloring cannot be applied to the total line in a Qlik Sense pivot table. At least, not that I am aware of. I looked into it awhile back, but did not find a solution for applying conditional color to the total line.