Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shaimamahmoud
New Contributor III

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

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

|  task_id   |   task_name   |   resource_Name |   Status

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

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

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

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

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

|-----  5 -----|---  Z Task 1 ---|--------- Adam ---------|-- ontime --|

|-----  6 -----|--- Z Task 2  ---|--------- Adam ---------|-- ontime --|

|----  7 ------|--- Z Task 3  ---|--------- Adam ---------|-- ontime --|

|-----  8 -----|--- Z Task 4  ---|--------- Adam ---------|---- late ----|

|-----  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%


please help.




1 Solution

Accepted Solutions
okolyug16
Contributor II

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

5 Replies
Not applicable

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

folow example

shaimamahmoud
New Contributor III

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

Not applicable

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

Dimension (resource_Name)

expression: =Count({<Status={'ontime'}>} task_id)/Count(task_id)

okolyug16
Contributor II

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

shaimamahmoud
New Contributor III

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