Interval Pivot Table

[bartvanwetten]

Dear all,

Can someone help me out on this one?

In the attached qlikview document there's a pivot with workinghours and minutes, shown as intervals.

Now I want an extra (total) column in wich i have the minutes as part of 100. So 30 minutes is 50% and 45 is 75% etc..etc..

Thank you all in advance!

Bart

[sunny_talwar · Accepted solution]

Check the attached may be

[bartvanwetten]

Hi Sunny,

again exactly what I needed!

Many thx.

Bart

[bartvanwetten]

Hi Sunny,

can i set alternative labels for the total expressions? (Can't find where...)

Thx.

Bart

[sunny_talwar]

Within your cycle group