Covered Market Area - Calculation in QlikView

[renuka_sasikuma]

Hi All,

Data:

CORPORATE	Drug Combination	Value
ABC	Aspirin	2000
ABC	paracetamol	3508
ABC	caffeine	4567
CDE	caffeine	7767
CDE	levodopa	2345
POR	paracetamol	6789
POR	Carbidopa	5604
TUV	Aspirin	1085
XYZ	caffeine	3423
XYZ	Carbidopa	1259
CVN	Abacavir/lamivudine	9087

Where I want to achieve IPM, CVM & CurrentCompany

So I achieved IPM & CurrentCompany KPI simply by putting SUM(Value) & SUM({$<Corporate={'ABC'}>}Value) respc.

Now I want to achieve CVM - Drug Combination of Corporate ABC & available for other corporate also.

I need the below Output Corporate = ABC

DRUG Comb	IPM	CVM	CurrentC
Abacavir/lamivudine	9087	0	0
Aspirin	3085	3085	2000
caffeine	15757	15757	4567
Carbidopa	6863	0	0
levodopa	2345	0	0
paracetamol	10297	10297	3508
Total	47434	29139	10075

I tried using this expression - Sum({<[Drug Combination] = p({<CORPORATE = {"ABC*"}>})>}Value) but no success

[benvatvandata · Accepted solution]

You're really close with the expression you have... change it to:

=Sum({<[Drug Combination] = p({<CORPORATE = {"ABC*"} >} [Drug Combination]) >} Value)

Thanks,

Ben

[renuka_sasikuma · Accepted solution]

Thank You @benvatvandata  

It worked for me with an additional condition.

=Sum({<[Drug Combination] = p({<CORPORATE = {"ABC*"} >} [Drug Combination]),CORPORATE= >} Value)