If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Where Condition for Load Script
Create Year should be less than 2021
If Stage =A then Close Year should be less than 2021 else no restriction for Close Year
Result: (Exclude highlighted in Yello)
T1:
LOAD * INLINE [
ID, Stage, Create_Yr, Close_Yr
1, A, 2018, 2018
2, A, 2018, 2021
3, C, 2017, 2020
4, C, 2018, 2018
5, A, 2018, 2021
6, D, 2018, 2020
7, D, 2018, 2020
8, E, 2021, 2022
9, E, 2018, 2023
10, H, 2021, 2025
];
Hello.
my suggestion:
T1:
LOAD * INLINE [
ID, Stage, Create_Yr, Close_Yr
1, A, 2018, 2018
2, A, 2018, 2021
3, C, 2017, 2020
4, C, 2018, 2018
5, A, 2018, 2021
6, D, 2018, 2020
7, D, 2018, 2020
8, E, 2021, 2022
9, E, 2018, 2023
10, H, 2021, 2025
]
Where (Create_Yr<2021) and not (Stage='A' and Close_Yr>2020)
;
Hello.
my suggestion:
T1:
LOAD * INLINE [
ID, Stage, Create_Yr, Close_Yr
1, A, 2018, 2018
2, A, 2018, 2021
3, C, 2017, 2020
4, C, 2018, 2018
5, A, 2018, 2021
6, D, 2018, 2020
7, D, 2018, 2020
8, E, 2021, 2022
9, E, 2018, 2023
10, H, 2021, 2025
]
Where (Create_Yr<2021) and not (Stage='A' and Close_Yr>2020)
;