Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
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

0 Replies