Solved: Re: Loading Calculated Facts - Page 2 - Qlik Community

Anonymous · ‎2014-10-27

Is it possible to load calculated 'Facts' when you are loading a table. I have a table with the following fields and records:

[Drug Name] and [Repeat or Original]

Frusemide Original

Frusemide Repeat

Frusemide Original

Frusemide Repeat

Amlodipine Original

Amlodipine Repeat

Amlodipine Original

i want to be able to load calculated fields based on the above records as follows:

Total Prescriptions (TRx) which is an aggregate count of all Original and Repeat records for all [Drug Name] field
New Prescriptions (NRX) which is an aggregate count of all Original only records for all [Drug Name] field
Total Drug Prescriptions (TDRx) which is an aggregate count of all Original and Repeat records for a particular [Drug Name]
New Drug Prescriptions (NDRx) which is an aggregate count of all Original only records for a particular [Drug Name]

if this is not possible, what is the alternative approach?

I hope my question is clear. Thanking you in advance.

Regards

Chris

Anonymous · ‎2014-10-30

Hello

Many thanks, if i select current month in the calendar it is returning the correct TRx count but this value is the same as the year to date value calculated as follows:

Sum({$<$(vSetYTD)>} Aggr(TextCount([Repeat or Original]), [Drug Code]))

I do not know what is going on.

regards.

Chris

Report Inappropriate Content · ‎2014-10-30

It will be great if you could post a sample file with expected numbers. That will help me and other members to give you prompt responses.

--Singh

Anonymous · ‎2014-10-30

Hello Singh

I managed to figure it out. I changed it to the following and it is now working:

Sum(Aggr(Count({$<$(vSetYTD)>} [Repeat or Original]), [Drug Code]))

Regards

Chris

Report Inappropriate Content · ‎2014-10-30

Great! Feel free to mark any answer as helpful or correct to close the thread.

Thanks,

Singh