topic Re: National Averages for Section Access.. field errors in QlikView

National Averages for Section Access.. field errors

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

Hi Folks

I'm doing doing Section Access with hospitals and breaking them into individuals hospitals but along with the just the data for that particular hospital I need to add the national average of all hospitals also.

The way Im doing it is I am creating a separate table with the the calculation, the problem Im having is it works for some and not for others!

I get an error say its can identify a particular field. But if I load it within the national data base I can see it.

Any idea why this may be happening I think its something to do with the loads

The below formula works but some don't as I said

Load

Num($(v%Assessed),'##.##%') as National_Assessed//

resident
Fact;

Re: National Averages for Section Access.. field errors

Gysbert_Wassenaar — Wed, 28 Nov 2018 18:01:18 GMT

I get an error say its can identify a particular field

Could you post the error?

Have you tried a debug load with a limited set of records to? That often makes it easier to see what's going wrong.

Re: National Averages for Section Access.. field errors

sweens78 — Thu, 29 Nov 2018 10:19:19 GMT

Re: Full Company vs Division When Section Access is Applied

Yes Of course ,

So when I try to create a table for the formula to then load in my tables I keep getting an error.

I may be going about this the wrong way. So I want to do the below calculation away fro the section Access to get the full company value rather than the section access that way the user can compare both

So for example when I run the below expression on a table for just the section access individual this will work no problems

Num((count(if (Interventions_ID = '1' and TimeBSPAx_ID = '1', NEWKEYID))-Count(if (Interventions_ID = '1' and TimeBSPAx_ID = '1', PatientsNotAssessed_ID)))/(Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.##%')

but once I create a table for it like the this one

Load
Num((count(if (Interventions_ID = '1' and TimeBSPAx_ID = '1', NEWKEYID))-Count(if (Interventions_ID = '1' and TimeBSPAx_ID = '1', PatientsNotAssessed_ID)))/(Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.##%') as [National > 2rs]

resident
Fact;

I get this error

Re: National Averages for Section Access.. field errors

Gysbert_Wassenaar — Thu, 29 Nov 2018 12:25:02 GMT

The error indicates that the field Interventions_ID does not exist in the table Fact from which you load the data.

Re: National Averages for Section Access.. field errors

sweens78 — Thu, 29 Nov 2018 14:10:33 GMT

Thanks Gysbert, so how do I go about including that in the Fact, apologies Im new qliview and trying to work it out?

Re: National Averages for Section Access.. field errors

Gysbert_Wassenaar — Thu, 29 Nov 2018 17:12:22 GMT

Perhaps you can join the field to the Fact table with the JOIN keyword. I don't know your data model so I have no clear idea what's the correct solution for your data model.