Qlik Community

Qlik Sense App Development

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

Highlighted
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
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,