Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
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