Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Creator
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

PieChart.JPG

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
Creator

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

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

 

Udklip.JPG

View solution in original post

4 Replies
Highlighted

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
Creator

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

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
Creator

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

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

 

Udklip.JPG

View solution in original post