Pulling from two different qvds into object

Anonymous — Mon, 26 Mar 2018 15:28:13 GMT

Hi everyone,

I have a text object that is currently summing the total number of Workers' Comp claims. The expression can be found below:

=Count(DISTINCT{$<

Period_Type={'Current'}

,Year={$(vCurrentYear)}

>}WCClaimNumber)

I want to pull additional WC claims from another qvd. The field I would be trying to pull from is

STDAbsenceType={'Workers' Compensation'} and the data would be under STDClaimNumber.

Is there a way to concatenate or join the two qvds to pull for one value in the text box?

Thank you!

Re: Pulling from two different qvds into object

olivierrobin — Mon, 26 Mar 2018 15:42:52 GMT

hello

you can concatenate the 2 qvds and aming one of the 2 fields so they have the same name and your formula is correct.

Or if you are sure there are no common values between the 2 qvds , modify your formula to add another count with the new field