Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

multiple relationship

HI,

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

Tags (1)
Community Browser