Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
gopal5879
New Contributor III

Need some help - perform SQL outer join like operation

Folks,

I am struggling to find solution, any ideas would be helpful. Appreciate your help

Basically, business needs to see on the dashboard PROVIDERS WITH CLAIMS HISTORY + PROVIDERS WITH NO CLAIMS HISTORY since their analysis target about TAXID's and PROVIDERS associated with TAXID. Not every PROVIDER may have claim history related to a TAXID.

Posted in some mock up data:

QlikView Model as below :
QlikViewModel.jpg

Output desired as below:

This is the part I am struggling  to report  PROVIDERS P2,P3  with 0 as they don't have utilization If I select Month of January,2018. The business still needs to see them with 0 utilization, any ideas would be helpful.  I tried different ways, but could not find appropriate solution.

Any suggestions to handle scenario like this would be of great help!

OutputDesired.jpg

Appreciate your time and help