I set the column of the pivot table to: Date.autoCalendar.YearMonth
I set the "Kennzahl" (is it KPI in english) to: Count([Date.autoCalendar.YearMonth])
and set the highlight field to:
if(Max([Prediction])=1,'red')
Note that the column Prediction can only have 0 or 1 values. The intention is that I get only those cells red marked where at least one prediction=1 is detected. But this doesn't seem to work consistently.
Example (assuming the very same dimension):
Date Prediction
17.10.2019 1
19.10.2019 0
21.10.2019 0
23.11.2019 0
I would expect to get a Pivot:
Oct 2019 | Nov 2019
3 | 1
Where the 3 is highlighted due to the prediction. But QlikSense highlights 3 and 1 😞
