Single filter for multiple fields

[suraj_qlik]

Hello Guys, 

I have 3 tables as shown:

KPI_1	Correlation_1	P_value_1
A	0.4	0.07
B	0.5	0.01

KPI_2	Correlation_2	P_value_2
A	0.4	0.07
B	0.5	0.01

KPI_3	Correlation_3	P_value_3
A	0.4	0.07
B	0.5	0.01

So I want a single correlation filter and single P_Value filter as below: if correlation1 or correlation_2 or correlation_3 >=0.8,"Good correlation", if correlation1 or correlation_2 or correlation_3 <=0.8,"Bad correlation" and similarly for P_value 1,2,3<=0.05,'"Significant" and P_value 1,2,3>0.05,'"Not Significant" 

Please help me. 

[JordyWegman]

Hi,

You can create an IF formula to get this to work. You have already written out how the logic should work.

Jordy

Climber

[Saravanan_Desingh]

Try this,

tab1:
LOAD KPI_1 As KPI,* INLINE [
    KPI_1, Correlation_1, P_value_1
    A, 0.4, 0.07
    B, 0.5, 0.01
    C, 0.9, 0.01    
];

Left Join(tab1)
LOAD KPI_2 As KPI,* INLINE [
    KPI_2, Correlation_2, P_value_2
    A, 0.4, 0.07
    B, 0.5, 0.01
    C, 0.1, 0.01   
];

Left Join(tab1)
LOAD KPI_3 As KPI,* INLINE [
    KPI_3, Correlation_3, P_value_3
    A, 0.4, 0.07
    B, 0.5, 0.01
    C, 0.1, 0.01   
];

Left Join(tab1)
LOAD KPI,
 If(RangeMax(Correlation_1, Correlation_2, Correlation_3)>=0.8, 'Good correlation', 'Bad correlation') As Cor_Result,
 If(RangeMin(P_value_1, P_value_2, P_value_3)<=0.05, 'Significant', 'Not Significant') As Val_Result
Resident tab1;

[Saravanan_Desingh · Accepted solution]

Output: