Restricting the available dimensions in a Pie chart

kevinstanfield — Tue, 28 Aug 2018 15:50:22 GMT

Hi, hopefully this is a simple one (and I'm sure I have done it before?) but I'm trying to limit a dimension in a Pie Chart in Qlik Sense

I have the following data relationship (simplified for the example)

Usage Group Call Class

Voice Call Class 1

Voice Call Class 2

Voice Call Class 3

Data Call Class 4

Data Call Class 5

Data Call Class 6

SMS Call Class 7

SMS Call Class 8

As each Usage Group has a different unit of measure e.g. voice is seconds, data is KB etc I just want a Pie Chart that allows the Call Classes associated with Voice to be displayed and the % mix of secs for the each Call Class to be displayed.

Is it possible to limit the pie chart in this manner?

I have had some success in this by using set analysis as follows:

(sum({$<USAGE_CHARGE_GROUP={'VOICE'}>}ACTUAL_DURATION))/60 and I only see the Call Classes associated with Voice in the pie chart but the legend shows all the Call Classes

Thanks

Kevin

Re: Restricting the available dimensions in a Pie chart

Quy_Nguyen — Tue, 28 Aug 2018 16:28:43 GMT

Hi Kevin,

In your pie chart, do this:

+ Dimension: =If([Usage Group]='Voice', [Call Class])

Remember to uncheck Include Null values

+ Measure: Sum(ACTUAL_DURATION)/60

Re: Restricting the available dimensions in a Pie chart

kevinstanfield — Wed, 29 Aug 2018 08:12:58 GMT

Thanks Quy, that's worked a treat.

topic Re: Restricting the available dimensions in a Pie chart in App Development

Restricting the available dimensions in a Pie chart

Re: Restricting the available dimensions in a Pie chart

Re: Restricting the available dimensions in a Pie chart