I have a slightly complex question.
I have a field in relation to two other fields in the same table.
as in the following example:
ISNULL ((SELECT FROM TA.TBL_LIB TABLES WHERE YOUR TA.TBL_ID = 'FC1' AND TA.TBL_CODE T.FC1_CODE =), '') AS 'C1_Tiers'
ISNULL ((SELECT FROM TA.TBL_LIB TABLES WHERE YOUR TA.TBL_ID = 'FC2' AND TA.TBL_CODE T.FC2_CODE =), '') AS 'C2_Tiers'
TBL_ID is in relation with the field FC1_CODE and is also related to the field FC2_CODE.
How to realize this relationship in Qlikview?
How to translate this SQL query?
T: Tiers TABLE
TA: Tables TABLE