Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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

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.`

4 Replies
Highlighted

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)>}
Highlighted
Partner
Partner

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

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

Highlighted
Master II
Master II

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)

Learning never stops.