topic Re: calculated dimension problem in QlikView

calculated dimension problem

sayanpwc — Mon, 18 Jun 2018 08:39:49 GMT

Hello Team,

Facing a problem. pls help.

Find below the scenario.

I have used calculated dimension for this below scenarion :

=if(CONCLUSION='Paper Zambia','Paper',

if(CONCLUSION='Paper Malawi','Paper',

if(CONCLUSION='Paper Hunyani','Paper',CONCLUSION))).

Now the % HELD field value is getting summed up for its individual values but i want this value for this field only to be expression total or avg. not summed up. So the value against Paper should be around 80% or so like that. How can I achieve that?

Pls help!!!!

Re: calculated dimension problem

pipuindia99 — Mon, 18 Jun 2018 11:49:04 GMT

Re: calculated dimension problem

pipuindia99 — Mon, 18 Jun 2018 11:50:40 GMT

Please see the screenshot which i have given. this could help you

in Expression put Avg(%Held)

Re: calculated dimension problem

sayanpwc — Tue, 19 Jun 2018 12:18:42 GMT

Hi Prabhu,

Thanks for your note. But now I want it for enterprise field not avg for all the dimension.

i.e for paper the enterprise value i want is sum(enterprise)/2 where as for rest of the dimension i want sum(enterprise).

How can I do that?

Pls help.