Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kevinstanfield
Partner
Partner

Restricting the available dimensions in a Pie chart

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

2 Replies
Quy_Nguyen
Creator III
Creator III

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

kevinstanfield
Partner
Partner

Thanks Quy, that's worked a treat.