Text color change in Qliksense

[nehapathak]

I have a pivot table and a date filter(Single selection filter)

when no date is selected from the filter the data in the table is of max date

when we select the filter the data changes accordingly but as the data changes I want to show the comparison via colors

if (count({$}empid) > count({$1}empid),green(),red() )

In case of landing page ie when no date is selected the color should be black ,  but on first selection the comparison should be made with default date (max date)

[YoussefBelloum]

so you want to compare the selected date with the max date to generate the colors ?

[nehapathak]

yes exactly but only on the first selection and afterwards the comparison should be done on current and previous selection of dates

[nehapathak]

hi

Kindly refer the below link for further explanation

Change in text color expression in Qliksense