topic Percentage per dimension in pivot table in QlikView

Percentage per dimension in pivot table

Wed, 27 Jun 2012 14:34:57 GMT

Hello!

I was wondering if somebody could tell me how to determine the percentage a certain dimension is using per row in the pivot table below?

Dimension1: [WorkType]

Dimension2: [Employee]

Expression1 (#): sum([BookedDays])

Expression2: ?

So if person 'CKE' has in total 241.2 days worked... 238.2/241.2 is the percentage this person worked on [WorkType] 'Work', while 3/241.2 is the percentage booked on [WorkType] 'Holidays'.

I already did all kinds of combinations (based on other topics), but none of them seemed to work...

Thanks in advance!

Maarten

Re: Percentage per dimension in pivot table

fosuzuki — Wed, 27 Jun 2012 16:41:00 GMT

maybe this expression will work:

sum([BookedDays]) / sum(total <Employee> [BookedDays])

Hope this helps you

regards

Fernando

Re: Percentage per dimension in pivot table

Thu, 28 Jun 2012 07:00:56 GMT

Dear Fernando,

Exactly what I was looking for!

Thanks a lot!

FYI: Actually I tried this myself too based on some other topic going arround on this fantastic forum.

But all results were equal to 1 or 0 because I did not put the number in '%' and the rounding without decimals (integer) made those numbers like 0.9 or 0.8 turn up as 1 or 0 (integer). Luckily you were there to push me again in that direction 🙂

Thx!

Maarten