topic Problem on expression using <total> for calculating percent of time in QlikView

Problem on expression using for calculating percent of time

Mon, 06 Feb 2012 19:22:08 GMT

Hello,

I have a problem with expression calculation.

I have three empoloyees, EmpA, EmpB and EmpC. I also have three activities, ActA, ActB and ActC. Each employee works on an activity and I get the total hours by using the expression sum(HoursWorked). I also calculate the % of hours the particular employee worked on a specific activity. The results are fine until I make a selection of an employee where the % of hours worked changes to 100% instead of remaining to the percentile it was prior to the selection. For caclulating the % I use the expression: sum(HoursWorked)/sum(total <Activities> HoursWorked).

Any help will be appreciated.

Thanks,

--John

Problem on expression using for calculating percent of time

swuehl — Mon, 06 Feb 2012 20:12:15 GMT

You can try disregarding the selection in the denominator:

sum(HoursWorked) / sum({<EmpName=>} total <Activities> HoursWorked)

And enable the option 'supress zero values' in presentation tab, if needed.

Hope this helps,

Stefan

Re: Problem on expression using for calculating percent of time

Tue, 07 Feb 2012 08:08:00 GMT

Hi,

maybe this modification of your expression is what you are looking for:

Sum(HoursWorked)/sum( {1} total<Activities>HoursWorked)

Good luck!

Rainer

Problem on expression using for calculating percent of time

Tue, 07 Feb 2012 21:56:18 GMT

It worked. Thank you very much!

Problem on expression using for calculating percent of time

Tue, 07 Feb 2012 21:57:49 GMT

Thank you Rainer.

Problem on expression using for calculating percent of time

Fri, 16 Mar 2012 10:47:37 GMT

Hi,

i think you can solve my problem

i've dimemsions dim1,dim2,dim 3..in hierarchial format as in pivot table.

i've a value column in the table, as one expr....i'm showing sum(value) and i also have dimension due date....& if the due date <today() date then in the expr column Overdue Amt i simply show sum(value) else i'll show it the Not due column...this is fine....

now i've to find %Overdue & %Not due.....wich is Overdue Amt/sum(value) & Not Due Amt/sum(value) respectively...

i'm getting the % fine..for each row...but at the total level i dnt want to see sum of all % for Overdue & %Not Due

Bt only the sum of Overdue Amt/sum of Remainin Amt & same for %Not due as well

Plz help

stuck for 1 day cmplete

Regards