Skip to main content

New to Qlik Sense

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

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zhaohaifeng
Contributor III
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.

zhaohaifeng_1-1611277994352.png

 

Haifeng

Labels (1)
1 Solution

Accepted Solutions
PriyankaShivhare
Creator II
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

View solution in original post

3 Replies
PriyankaShivhare
Creator II
Creator II

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

Thanks,
Priyanka

)
zhaohaifeng
Contributor III
Contributor III
Author

Thanks for your help.

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

PriyankaShivhare
Creator II
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