5 Replies Latest reply: Aug 2, 2016 7:01 PM by Shaima Mahmoud

# how to represent a percentage and its complement in a pie chart of same resource as in the following explanation

I have a data table as follows

|---------------|----------------------|----------------------------|---------------|

|---------------|----------------------|----------------------------|---------------|

|-----  1 -----|----   task 1  ----|--------- John  ---------|-- ontime --|

|-----  2 -----|----   task 2  ----|--------- John  ---------|---- late ----|

|-----  3 -----|----   task 3  ----|--------- John  ---------|---- late ----|

|-----  4 -----|----   task 4  ----|--------- John  ---------|-- ontime --|

|-----  9 -----|---  V Task 1 ---|--------- Scott ---------|---- late ----|

|---- 10 -----|--- V Task 2 ----|--------- Scott ---------|---- late ----|

|----- 11 ----|--- V Task 3  ---|--------- Scott ---------|-- ontime --|

|---- 12 -----|--- V Task 4 ----|--------- Scott ---------|---- late ----|

|---- 13 -----|--- V Task 5  ---|--------- Scott ---------|-- ontime --|

|---- 14 -----|--- Th-Task 1---|--------- Emily ---------|-- ontime --|

|---- 15 -----|--- Th-Task 2---|--------- Emily ---------|-- ontime --|

|---- 16 -----|--- Th-Task 3---|--------- Emily ---------|-- ontime --|

I am trying to count ontime tasks aginst late tasks for every resource_name in a pie chart as follows and the selected resource from a selection pane

John 50% ontime , 50 late

Adam 75% ontime , 25% late

Scott 40% ontime , 60% late

Emily 100% ontime, 0% late

I want for example to select John so the pie chart view the value of John progress only,  50% and 50% or select Scott so the pie chart change to Scott's progress values 40% and 60%

• ###### Re: how to represent a percentage and its complement in a pie chart of same resource as in the following explanation

folow example

• ###### Re: how to represent a percentage and its complement in a pie chart of same resource as in the following explanation

I am using Qlik Sense not Qlik View , all my apps are .qvf , this file is not working

• ###### Re: how to represent a percentage and its complement in a pie chart of same resource as in the following explanation

Dimension (resource_Name)

• ###### Re: how to represent a percentage and its complement in a pie chart of same resource as in the following explanation

Hey Shaima,

Try setting up the pie chart as described below;

Dimension = Status

Measure = Count([Task ID]): This should give you the percentage of each status per resource selected,

Hope this helps

• ###### Re: how to represent a percentage and its complement in a pie chart of same resource as in the following explanation

Thanks, your idea is right and worked