Calculate % of a value and show value + remaining value

[amber2000]

Hi to you all,

I want to calculate a percentage of time. (I'm using Qlikview version 12)

PA_SecondsWorked (00:02:31) is 0,58 % of TR_Num_Minutes(07:15:00)

The calculation of the 0,58 % is already successful, now I also want to see the remaining 99,42%

To show those 2 values of % I want to use a bar chart.

I've attached my example with a small amount of data so it's easier to see what I want to accomplish, does anybody have a clue???

Monique

[amber2000]

Hello Manuel,

You are absolutely wright and your solution works as well.

Thank you, this is also helpful to understand why it didn't work in the first place.

Kind regards,

Monique