Lookup in Qlikview with adjustable variables

[kpatelacmm]

I am trying to have qlikview do some kind of a lookup for a specific value but in a specific order. I also need qlikview to be able to do this in real time without having to reload the document.

This is an example of the starting point.  I have a list of 27,577 categories and based on priority I need to look up all the diagnosis_codes and in the Capturesource flag put what the source is. So first it will go to the claims and look up all the diagnosis_code’s and which ever matches it will flag that line as CLAIM then the lookup goes to priority 2 which is GFPCPO and looks up and flags those lines etc through all the priorities. I need to be able to adjust the priorities freely. So if we decide claim is going to be priortity 2 and GFPCPO to priority 1 then I need to adjust something in qlikview manually and then it should recalculate and we should get new numbers withou reloading any data.

Hcc Risk	HCC	CaptureSource	Rank	diagnosis_code
HCC52^	52	CLAIM	1-CLAIM	304.01
HCC131^	131	CLAIM	1-CLAIM	403.91
HCC131^	131	CLAIM	1-CLAIM	585.2
HCC19^	19	GFPCPO	2-GFPCPO	250
HCC19^	19	GFPCPO	2-GFPCPO	250.02

This is an example of what will happen if claim is priority 1 and GFPCPO is 2. I have others as well that are priotized but i am only using the first two in the example.Those can be added once the logic is working.

Unique	1
Count of MRN_HCC	Column Labels
Row Labels	1-CLAIM	2-GFPCPO	3-GFPCPN	4-GFSpec	5-HRAPCP	6-HRAAVP	7-CAPCP	8-CASpec	9-CAHOSP	#N/A	Grand Total
NO	58	261	83	4	4	16	15	2		5,437	5,880
YES	17,400	2,505	777	20	61	235	292	37	31	339	21,697
Grand Total	17,458	2,766	860	24	65	251	307	39	31	5,776	27,577

[Gysbert_Wassenaar]

Yes, I do have an idea. Post the script that causes the loop. My clairvoyance module broke down earlier this week so can't read your mind at the moment to find out what you're doing in your qlikview document that causes the loop/

[kpatelacmm]

Hi Gysbert,

I have attached a copy which is causing the loop error.

What I am trying to do is I need to be able to add a cost by source and by providername. Overall everything works at a high level or at the source level. If I pick providername all the numbers change and everything works. There is one piece which is the cost of each source by providername which I need to add so when I do pick a providername the cost reflects that providername by the appropriate source. I have added another table which has the source, provider name and cost, but that's where the loop comes into play.

Thank you,

Krishan

Krishan Patel | Senior Financial Analyst

AppleCare Medical Management

6131 Orangethorpe Ave, Ste 280 | Buena Park, CA 90620

direct: 714-452-5087 | facsimile: 714-443-4540

Krishan.Patel@applecaremedical.com<mailto:Krishan.Patel@applecaremedical.com>

This electronic message transmission, including any attachments, contains information from AppleCare Medical Management, which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or uses of the contents of this information is prohibited

If you have received this electronic transmission in error, please notify the sender immediately by calling AppleCare Medical Management at 714 443-4500 or sending a "reply to sender only" fax to 714 443-4540. Please destroy all electronic and hard copies of the communication, including attachments.