Discussion board where members can learn more about Qlik Sense App Development and Usage.
I want a percentage, that work also as a filter for this thing. Here this is an example of the table.
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
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