How do I add a field to a fact table

sweens78 — Fri, 30 Nov 2018 10:43:30 GMT

Hi Guys

I have a field outside the fact table so when I go to query when using section access it says its doesn't recognise field.

Is it a join statement I must use? If so is there a away to hide so its does skew the data I have in the original Fact table.

This is the statment Im having problems with

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 AGGR

Resident
Fact;

It doesn't recognise the intervention id but if I put a join where the intervention Id is in the script it see it but it skews my data figures

Any ideas?

Join(Fact)
Interventions:
LOAD "Interventions_ID",
"Interventions_Types" AS [Interventions];
SQL SELECT "Interventions_ID",
"Interventions_Types"
FROM "NCPMH_COPY_2".dbo."Dim_Interventions";

Re: How do I add a field to a fact table

lironbaram — Fri, 30 Nov 2018 13:33:19 GMT

script functions in general are calculated on fields in the same table ,

why connecting between the two tables skew your numbers , do you have many to many relations

may be as you only interested in cases where Interventions_ID =1

you can use it as a where clause in your dimension table connecting only records you are interested in ,

what is the key field between the two tables?

topic How do I add a field to a fact table in QlikView

How do I add a field to a fact table

Re: How do I add a field to a fact table