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: 
DataAnalytics
Contributor II
Contributor II

calculated dimension - incorporate more than one Attribute

hello guys,

I am looking to create a pie chart from the values below. The graph should look like this:

first value should be sum of Attribute A (for all owners) / sum of total items

second value should be sum of Attribute B / sum of total items

the last value should be sum of items without any attributes / sum of total items (e.g. for owner A it is 12 -3 = 9)

 

OwnerTotal_ItemsAttribute_AAttribute_B
A1230
B1015
C840
D621

 

Please advise on how to set the dimension and expression. I am a beginner obviously 🙂

 

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Use no dimension, and three expressions in your pie chart. 

View solution in original post

4 Replies
Taoufiq_Zarra

can you explain or the output from :

"the last value should be sum of items without any attributes / sum of total items (e.g. for owner A it is 12 -3 = 9)"

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
DataAnalytics
Contributor II
Contributor II
Author

hello,

the output graph should look like this:

 

DataAnalytics_0-1593521062991.png

Attribute A = sum of column Attribute_A

Attribute B=sum of column Attribute_B

No Attribute=sum of column Items - sum of column Attribute_A -  sum of column Attribute_B

tresesco
MVP
MVP

Use no dimension, and three expressions in your pie chart. 

DataAnalytics
Contributor II
Contributor II
Author

it works!! thank you!