Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

custom color for lagged variables..with Above function?

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

Community Browser