# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for
Did you mean:
Highlighted
Creator

## Multiple Dimensions in Pie Chart

Hi

I have 3 Pie Charts, that each represent a different dimension. Those Dimensions are used with a timestamp as a measure.

Dim 1,
Dim 2,
Dim 3,
TimeStamp

What I need to figure out, is how I can get the 3 dimensions combined so I can calculate the AVG of the 3 dimensions.

1 Solution

Accepted Solutions
Highlighted
Creator

## Re: Multiple Dimensions in Pie Chart

I found a solution using the Load script and creating a new dimension

Dim1&' '&Dim2&' '& Dim3 as DimensionForPieChart

4 Replies
Highlighted
MVP

## Re: Multiple Dimensions in Pie Chart

You could do something along the lines of this pattern:

=RangeAvg(<measure for pie 1>, <measure for pie 2>,....)

There may be a more efficient way, but it depends on the expression for the measures.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Creator

## Re: Multiple Dimensions in Pie Chart

Maybe, but could you please dumb it down a bit 🙂
I am not a specialist in Qlik sense (yet)

So you were thinking a dimension consisting of

=RangeAvg(<if(dim1=''timestamp>, <if(dim2=''timestamp>,<if(dim3=''timestamp>)

Highlighted
MVP

## Re: Multiple Dimensions in Pie Chart

Its not really possible to be more specific without a lot more information from your side - dimensions and measure for each pie and the output values that you expect. Is timestamp a field, a variable or a literal?

I was thinking of that as a measure - and it is a pattern, so replace the <....> with the relevant expressions from your side. if all the dimensions are the same, then use the same dimension again for the average.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Creator

## Re: Multiple Dimensions in Pie Chart

I found a solution using the Load script and creating a new dimension

Dim1&' '&Dim2&' '& Dim3 as DimensionForPieChart