topic Re: Covered Market Area - Calculation in QlikView in QlikView

Covered Market Area - Calculation in QlikView

renuka_sasikuma — Mon, 15 Mar 2021 10:58:30 GMT

Hi All,

Data:

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

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

benvatvandata — Tue, 16 Mar 2021 03:51:24 GMT

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 — Tue, 16 Mar 2021 06:13:04 GMT

It worked for me with an additional condition.

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