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

Formula error

Hello All,

I am having an issue in writing a formula.

Could you please help:

If([Résolution Time] > Interval#('4', 'hh')and([Résolution Time] < Interval#('10', 'hh')),Interval#('10', 'hh')) - Interval#('4', 'hh'),0)

I think I am not doing it correctly.

Actually i need a formula which states that if the [Résolution Time] is more than 4 hours and less 10 hours, it show as 6 hours in my Excess field and if [Résolution Time] is less than 4 hours it shows as 0.

Many thanks for your usual help.

Kind Regards,

Hasvine

11 Replies
sunny_talwar

Would you be able to share a sample to check out the issue?

Best,

Sunny

Not applicable
Author

Hi Sunny,

Thanks for your help. I manage to solve the issue.

Thanks,

Hasvine