Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
marcouser
Contributor
Contributor

Pie Chart - Several dimensions must add up to a defined number

Hi everyone.

I would like to create a Pie Chart with 7 dimensions:

GDP per capitaSocial supportHealthy life expectancyFreedom to make life choicesGenerosityPerceptions of corruptionDystopia
1.341.5870.9860.5960.1530.3932.714

These dimensions "GDP per capita" , "Social support", "Healthy life expectancy","Freedom to make life choices", "Generosity","Perceptions of corruption" and  "Dystopia" add up to a score, in this case

Score
7.769

 

The pie chart must represent the score with its parts representing the dimensions.

Combining the dimensions (GDP per capita&Social support&...) to one dimension and setting the score as Measure did not work. Is there a way to solve this? 

Thanks in advance!

Labels (1)
2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

what you should try to do 

is in the load script run a crosstable function so in the end the Table will look like this 

Annotation 2020-04-19 172059.png

than building the chart would be easy 

marcouser
Contributor
Contributor
Author

Thanks for your reply,  it worked!