Qlik Community

Qlik Sense App Development

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

MarcoAmbrosio
New Contributor

measure expression and dimension in pie chart

I want a percentage, that work also as a filter for this thing. Here this is an example of the table.

CodOfficeIdPractice
10154645
101123546
102-
1034568
1047987

 

In my pie chart a want a percentage of how many CodOffice have at least one IdPractice and how many CodOffice don't have an IdPractice

1 Reply
Highlighted
Diter
New Contributor III

Re: measure expression and dimension in pie chart

Hi Marco,

Maybe this can help you.

1. you can add a category calculated with a formula: if([IdPractice]>0, 'at least one id Practice', 'dont have an Id Practice')

2. then you can count the CodOffice:  count(distinct CodOffice)

3. finally you can built the pie chart and use it as a filter

Please see attached images

 

Regards,