topic Re: Baby user - learning in QlikView

Baby user - learning

derekledbetter — Wed, 25 Nov 2020 16:16:04 GMT

Good Morning and Happy Friday!

Our company has embarked on using QLIK. I am in the training phase and have been working through a book reading, while using my data for building an application.

SELECT

a.PatientID

, a.MRN

, a.CurrentActiveDTS AS CareManagementDTS

, b.LastUpdateDTS AS PayorLastUpdateDTS

, a.CurrentActiveFLG as CurrentMember

FROM

Work.CareManagementPatients a

INNER JOIN

Work.NextGenRoster b on a.PatientID = b.PatientID

--result 512 rows. (which I got)

SELECT

a.PatientID

, a.MRN

, a.CurrentActiveDTS AS CareManagementDTS

, b.LastUpdateDTS AS PayorLastUpdateDTS

, a.CurrentActiveFLG as CurrentMember

FROM

Work.CareManagementPatients a

INNER JOIN

Work.NextGenRoster b on a.PatientID = b.PatientID

WHERE

a.CurrentActiveFLG = b.ActivePayorFLG and a.CurrentActiveFLG=1

(which I can't) -- result is 191

ISSUE: I was using the "one table" method and trying to join them, which I did. Then, I figured the formula for adding. Then, I was using "set analysis" and that worked. However, I wanted to JOIN IE perhaps, link and I did finally. The issue in the "LINKTable" is the fact my data in PREVIEW is not showing. How to load a table, update that table with other values?

Any help is greatly appreciated in advance.

Thanks for the time and attention in this matter in advance.

Re: Baby user - learning

derekledbetter — Fri, 03 Mar 2017 19:20:11 GMT

Figured it out using the "INNER JOIN". What if, this table is in memory. Then, the other is in memory. Then you want to create an "INNER JOIN" - linktable. How does one get data in where they both have a match?

Re: Baby user - learning

jer_2011 — Fri, 03 Mar 2017 22:07:15 GMT

In the following link there are examples, you can help

regards

Inner ‒ QlikView

Re: Baby user - learning

derekledbetter — Mon, 06 Mar 2017 13:44:50 GMT

Good Morning,

I knew that I could use the inner join. What if, one .loads one table per script. That means the tables are in memory. How does one create the "inner join" at that point? Or can it be done?