Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 🙂

 

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: calculated dimension - incorporate more than one Attribute

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

View solution in original post

4 Replies
Highlighted
Specialist III
Specialist III

Re: calculated dimension - incorporate more than one Attribute

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 "
Highlighted
Contributor II
Contributor II

Re: calculated dimension - incorporate more than one Attribute

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

Highlighted
MVP
MVP

Re: calculated dimension - incorporate more than one Attribute

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

View solution in original post

Highlighted
Contributor II
Contributor II

Re: calculated dimension - incorporate more than one Attribute

it works!! thank you!