This content has been marked as final. Show 3 replies
i am trying to write this statement in qlik sense inside my script but it does not working.
select ID from EventsTimeline where ComplexTypeID='$(complexid)' and EventsTimeline.ComplexTypeID IN (SELECT ID FROM ComplexType WHERE ComplexType.ParentID='$(parentid)') ;
how can write it correctly.