topic Re: National Market Project Factor in QlikView

National Market Projection Factor

Anonymous — Wed, 25 Nov 2015 16:26:52 GMT

I have the following preceding load:

[Distinct Script Data]:

LOAD [Script Number],

Count([Script Number]) as Rx

Group by [Script Number];

SQL SELECT DISTINCT

"Script Number"

FROM PharmaMarketAudit.dbo.tblDatawarehouseConsolidatedCleanStage

WHERE [Date Dispensed] >= '2012-01-01' and [Date Dispensed] <= '2015-08-31';

I want to make a projection from a sample to a national market figure by multiplying the Count([Script Number]) as Rx by a factor of 3, in other words tripling the count. How can this be achieved with above load script at load time?

Regards

Message was edited by: Christopher Chitemerere

Re: National Market Project Factor

Wed, 25 Nov 2015 16:36:28 GMT

have you tried

Count([Script Number])*3 as Rx

I have done this same type of concept in expressions but not in the load

Re: National Market Projection Factor

Anonymous — Wed, 25 Nov 2015 16:45:25 GMT

Thank you Adam, you are right i tried it but was getting unexpected values. I later realized that i had not adjusted one of my variables in order to effect this.