Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

adamsmithsba
New Contributor II

Querying XML

Hi All,

ASD.png

Above is my XML which I have been able to query to a certain point. However, I am having trouble linking the "CP" element back to the RId.

How would you get the RId?

My XML Query looks like;

XMLOutput:

Load

RId as RatingJoin,

PIncIPT ,

PExIPT ,

PIncIPT - PExIPT,

From_Field('Policy','RD') (xmlSimple, table is [RatingData]);

CPOutput:

Load

[RatingData/RId],

I as [True/False],

V

From_Field ('Policy','RD') (xmlSimple, table is [RatingData/CP/CPI])

where I = 'true'

but for the life of me, I cannot join CPOutput to join back to the RatingData XMLQuery.....

Community Browser