Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

warrentk80
New Contributor III

Integer in format date

Hello to all

I have a calculated field as the ratio of total ticket and the total time taken for resolution.

the result is an integer that should express in hours to have a mean time to resolution.

would know someone help me out

For example, the ratio between the total time of taking charge and the total ticket the result is 1.3

tell me someone would know how to express this value in hours?

thanks

Andrea

2 Replies

Re: Integer in format date

What is your expression to get this ratio?

Re: Integer in format date

May be your formula will be something like this

Num(Text(Interval(TotalTime, 'h'))) / TotalTicket

TotalTime is total time of taking charge - Difference between 2 datetime.

Community Browser