Hi all,
I have two variables:
1)current:
Count(ALERTDATE)
2) average of last two periods ( I used above function get the average of t-n period) :
(Above(Count(ALERTDATE),1,1) +Above(Count(ALERTDATE),2,1))/2
See the pic below:
Qlik Sense built seleciton: Multicolor enables me to get the different colors for both. But I want to use another customized color.
How do i integrate second variable in the color code, if it is created by above function????
I want for example: count(ALERTDATE), green()
+ (Above(Count(ALERTDATE),1,1) +Above(Count(ALERTDATE),2,1))/2, red()
tx you in advance,
best
Rustam
![Sample.jpg](/legacyfs/online/83731_Sample.jpg)