Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sayanpwc
Partner - Contributor II
Partner - Contributor II

calculated dimension problem

Hello Team,

Facing a problem. pls help.

Find below the scenario.

img2.PNG

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))).

img1.PNG

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!!!!

3 Replies
pipuindia99
Creator III
Creator III

Qlikcomm.jpg

pipuindia99
Creator III
Creator III

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

in Expression put Avg(%Held)

Qlikcomm.jpg

sayanpwc
Partner - Contributor II
Partner - Contributor II
Author

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.