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

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

shivika123 — Fri, 08 Feb 2019 12:16:53 GMT

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

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

sunny_talwar — Fri, 08 Feb 2019 12:21:36 GMT

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

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

shivika123 — Fri, 08 Feb 2019 13:13:07 GMT

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

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

sunny_talwar — Fri, 08 Feb 2019 13:16:44 GMT

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

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

pradosh_thakur — Fri, 08 Feb 2019 13:33:25 GMT

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)