Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Number Format error SLA calculation?

Hi.

i am having difficulties with the following calculation.

i wish to calculate the total calculated time of each case against the SLA time assigned.

the two dimensions are Duration (actual calculation) and TotalAllowance ( the time threshold that the case should not pass)

if(Duration > TotalAllowance, 0,1)

However when i perform this calculation it seems as if the format is not recognized as it doesnt appear to work; in the correct way.

i have attached the Qvw to this message.

Help would be much appreciated.

Best,

Bradley

1 Solution

Accepted Solutions
Gysbert_Wassenaar

TotalAllowance is 48. That means 48 days if you use it as an interval. If you use num(duration) you can see how that compares to TotalAllowance. You either need to divde TotalAllowance by some factor or multiply Duration with a factor so both can be compared correctly.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

TotalAllowance is 48. That means 48 days if you use it as an interval. If you use num(duration) you can see how that compares to TotalAllowance. You either need to divde TotalAllowance by some factor or multiply Duration with a factor so both can be compared correctly.


talk is cheap, supply exceeds demand