Community
This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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