# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for
Did you mean:
Contributor III

## One measure depend on other measures

Hi All,

Now we have the requirement , for the employees they have performance A/B/C,

if two or more performance are -1, like Frank as below then we set red background color;

if one performance is -1, like Tony as below then we set Yellow background color;

If all the performance is 1 like Emily as below then we set Green background color;

How can we write the expression for the requirement? Thanks in advance.

Haifeng

Labels (1)
• ### Qlik Sense

1 Solution

Accepted Solutions
Creator II

May be Like this

u can manipulate column itself

if(PA>0,1,-1),if(PB>0,1,-1),if(PC>0,1,-1)

then use

if(RangeAvg(PA,PB,PC)=1,green(),
if(Rangesum(PA,PB,PC)<= -2,red(),
Yellow()))

Thanks,

Priyanka

3 Replies
Creator II
if(RangeAvg(PA,PB,PC)=1,green(),
if(Rangesum(PA,PB,PC)<= -2,red(),
Yellow()))

Thanks,
Priyanka

)
Contributor III
Author

But maybe have the performance -2,-3,2,34..etc in the future, its better to judge for performance <0 or >0, do you have any ideas? Thanks.

Haifeng

Creator II

May be Like this

u can manipulate column itself

if(PA>0,1,-1),if(PB>0,1,-1),if(PC>0,1,-1)

then use

if(RangeAvg(PA,PB,PC)=1,green(),
if(Rangesum(PA,PB,PC)<= -2,red(),
Yellow()))

Thanks,

Priyanka

Tags
Community Browser