Percentage on Y axis for a bar chart using Set Analysis and Total function

[SkitzN27]

load * Inline [

Responsible Person, Phases, Value
Tom, Phase 1, 30
Tom, Phase 2, 20
Tom, Phase 3, 50
Jack, Phase 1, 10
Jack, Phase 2, 20
Jack, Phase 3, 10
Jack, Phase 4, 25
Kate, Phase 1, 10
Kate, Phase 2, 10
Kate, Phase 3, 50

]

Hi guys,
Here's a sample data that I have.
I just want to consider sum(Phase 1 and Phase 2) and present the numbers in percentage (Y- Axis)

I want to create a bar chart like this.
How can I do it?

I believe we have to use Total function and Set Analysis.

Also, in the real data set, I have around 100 phases and I just have to display 5 out of it.

@Kushal_Chawda  @Taoufiq_Zarra 

Thank you so much,

N

[SkitzN27]

Hi Kush,

By numbers, I meant the values.

Like for Tom, it should display 30 & 20 on the bars (it's okay if we can't display the percentage with it, just the values will be fine too.)

For Kate, it should display 10 and 10

And for Jack, it should display 10 and 20.

(same as the last picture that I shared with you)

@Kushal_Chawda 

-N

[Kushal_Chawda]

@SkitzN27  see the attched

[SkitzN27]

You're great, thanks so much. @Kushal_Chawda 

[SkitzN27]

Can you also tell me, how I can display the same kind of bar chart in Qlik sense?

Single bar that represents two measures.

@Kushal_Chawda 

Thanks,

N

[Kushal_Chawda]

@SkitzN27  You can add same dimension and expression in qlik sense