how to write a set analysis comparing two date from different table

[shivika123]

Need to write Qlikview syntax having two date from different table but linked with many to many relationship need to write P() expression for it.`

[sunny_talwar]

P() will only work if you would like to see all possible values from one field in the other one.... If you do, then you can do this

{<FieldTable1 = p(FieldTable2)>}

[shivika123]

correct me where it is getting wrong
P(%PK_AILR_ORG_SUBMITTER = {'=[CLM Open Date (CST)]<[Org Deactivation Date (GMT)]'}

[sunny_talwar]

I don't think I understand your set expression... do you have a sample you can share?

[pradosh_thakur]

Please add the dimension for which you need the possible values. This expression will only work if  %PK_AILR_ORG_SUBMITTER  has a unique combination of [CLM Open Date (CST)] and [Org Deactivation Date (GMT)] and again you dates must not be in string format. You had missed a bracket at last but most probably that is a typo.

P(%PK_AILR_ORG_SUBMITTER = {'=[CLM Open Date (CST)]<[Org Deactivation Date (GMT)]'}   dimesnion_value)