topic Re: calculated dimension - incorporate more than one Attribute in QlikView

calculated dimension - incorporate more than one Attribute

DataAnalytics — Sat, 16 Nov 2024 18:25:39 GMT

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)

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

Taoufiq_Zarra — Tue, 30 Jun 2020 09:20:39 GMT

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

DataAnalytics — Tue, 30 Jun 2020 12:47:04 GMT

hello,

the output graph should look like this:

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

tresB — Tue, 30 Jun 2020 13:11:41 GMT

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

DataAnalytics — Tue, 30 Jun 2020 13:57:35 GMT

it works!! thank you!