Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

join clause within a master item measure

Hi All

Is it possible to have inner join created while defining master items..

e.g. I am trying to define something like this within the expression of a master item measure:

Count(distinct (Employee.[EmpID-EmployeeID] inner join Order.[EmpID-EmployeeID]))

Is it too outrageous??

1 Reply
Honored Contributor II

Re: join clause within a master item measure


yes we can do that, in the back end script try to use exists function and also we can use inner join. would be able to share your mock data and expected output here. thanks