topic Re: hours percentage % calculation in QlikView

hours percentage % calculation

buzzy996 — Fri, 26 Feb 2016 16:11:22 GMT

hi,

can some one help similar in this excel file in qlikview?

thanks

Re: hours percentage % calculation

sunny_talwar — Fri, 26 Feb 2016 16:13:13 GMT

Seems like you are just dividing a Time duration by another time duration. Is it not working? What is the issue?

Re: hours percentage % calculation

buzzy996 — Fri, 26 Feb 2016 16:15:35 GMT

PFA Actual problem,yes sunny.u r right,but not getting the same % value in qlikview.

any help?

Re: hours percentage % calculation

sunny_talwar — Fri, 26 Feb 2016 16:22:31 GMT

Seems to be working for your sample in QV. But I am guessing there are other factors in your actual app which might be causing the issue.

Re: hours percentage % calculation

sunny_talwar — Fri, 26 Feb 2016 16:23:09 GMT

Could be that the field you are using are timestamps and not just time?

Re: hours percentage % calculation

buzzy996 — Fri, 26 Feb 2016 16:26:53 GMT

added my screen shot in above post,could u see that?

Re: hours percentage % calculation

sunny_talwar — Fri, 26 Feb 2016 16:33:08 GMT

Can you try this:

=Interval#(Budget, 'hh:mm:ss')/Interval#(Actual, 'hh:mm:ss')

Re: hours percentage % calculation

Digvijay_Singh — Fri, 26 Feb 2016 16:34:15 GMT

the sample is working fine for me also- e is

Re: hours percentage % calculation

buzzy996 — Fri, 26 Feb 2016 16:37:31 GMT

no difference..still getting like same as above my screenshot % val.

Re: hours percentage % calculation

buzzy996 — Fri, 26 Feb 2016 16:39:03 GMT

without tested i placed sample..sorry,attached actual screenshot above.

Re: hours percentage % calculation

sunny_talwar — Fri, 26 Feb 2016 16:40:39 GMT

What is the output for first row (Aaakanksha1?) It should be 1.4%, are you getting that or another number? From the screeenshot it seems you are getting all nulls?

Re: hours percentage % calculation

buzzy996 — Fri, 26 Feb 2016 16:48:51 GMT

value should be 1.47%,after applied above syntax even getting all are null values.

Re: hours percentage % calculation

sunny_talwar — Fri, 26 Feb 2016 16:56:28 GMT

What about this:

=Num(((SubField(Actual, ':', 1) * 3600) + (SubField(Actual, ':', 2) * 60) + (SubField(Actual, ':', 3)))/

((SubField(Budget, ':', 1) * 3600) + (SubField(Budget, ':', 2) * 60) + (SubField(Budget, ':', 3))), '##.00%')

Re: hours percentage % calculation

buzzy996 — Fri, 26 Feb 2016 17:00:52 GMT

will try and let u know..many thanks for your help.