# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Contributor III

## Calculate percent on top of sum

Hello Everyone!!

I need to calculate percentage on sum of Date which is in day, hour and min format. I have calculation in 2 columns:

Time taken by BAS Team

Formula used-

interval(sum(Aggr(
if ("Modified Group Name"='BAS',
Interval(sum(Aggr(Interval(Rangemax(Interval((Above(TOTAL [Modified Date],1) - [Modified Date])*(-1), 'd.hh.mm'),0),'d.hh.mm'),
[Ticket Number],([Modified Date], (NUMERIC)))),'d.hh:mm'),0),[Ticket Number],([Modified Date],(NUMERIC)))),'d.hh:mm')

Total Resolution Time- Overall time consumed

Formula Used-

Interval(sum(Aggr(Interval(Rangemax( Interval((Above(TOTAL [Modified Date],1) - [Modified Date])*(-1), 'd.hh.mm'),0),'d.hh.mm'),
[Ticket Number],([Modified Date], (NUMERIC)))),'d.hh:mm')

Now the requirement is , I want to calculate the time in percentage and not in sum. Like how much percent BAS team worked and how much percent in total time spent.

Please note I have multiple tickets.

 Ticket Number Modified Group Name Modified Date Time taken by BAS Team(Days/Hour/Min) Total Resolution Time(Days/Hour/Min) 2.01:59 25.15:37 17623648 Desk 9/6/2019 7:37 0.00:00 0.00:00 17623648 CEM 9/6/2019 14:51 0.00:00 0.07:13 17623648 OS 9/13/2019 6:44 0.00:00 6.15:53 17623648 CEM 9/17/2019 9:59 0.00:00 4.03:15 17623648 DESK 9/23/2019 8:52 0.00:00 5.22:52 17623648 CEM 9/24/2019 8:02 0.00:00 0.23:10 17623648 BAS 9/26/2019 10:02 2.01:59 2.01:59 17623648 CEM 9/26/2019 15:32 0.00:00 0.05:30 17623648 DESK 10/1/2019 23:15 0.00:00 5.07:43

Kindly help!

1 Solution

Accepted Solutions
Highlighted
Creator

Hi,

Convert the duration into seconds  and then calculate the %.

or

(column(1)/column(2))*100

Thanks,

Priyanka

Highlighted
Creator

Hi,

Convert the duration into seconds  and then calculate the %.

or

(column(1)/column(2))*100

Thanks,

Priyanka