Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MCmiranda
Contributor II
Contributor II

Pie Chart without dimension

Hi all,

I have used the search, but I don't exactly know how to search this, I hope someone can help me..

I want a pie chart wihout setting a specific dimension, just the sum of values in that column.

In Excel you can use the sum of values of a specific column, and the dimension is the name of that column (axis=Values).

So what I need:

Column A = Total of 5000
Column B = Total of 5000
Column C = Total of 5000
Column D = Total of 5000
Than I want to see a pie chart, with 4 quarters of 5000 and each is named afterthat Column.

Am I making sense?

Labels (3)
2 Replies
forte
Partner
Partner

Hi @MCmiranda 

Just try using valuelist. On dimension , write down something analogue to Valuelist('A','B','C',D')

After that, add a Measure with something similar to this

if(ValueList('A','B','C','D') = 'A',sum(A), //expression for column A
if(ValueList('A','B','C','D') = 'B',sum(B), //expression for column B
if(ValueList('A','B','C','D') = 'C',sum(C), //expression for column C
if(ValueList('A','B','C','D') = 'D',sum(D), //expression for column D
))))

Hope it helps

Regards

MCmiranda
Contributor II
Contributor II
Author

Thanks! I get the picture 🙂