topic Re: Formula error in QlikView

Formula error

Tue, 02 Jun 2015 12:07:19 GMT

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

Re: Formula error

sunny_talwar — Tue, 02 Jun 2015 12:14:43 GMT

What exact error are you getting? Will it possible to share a sample?

Best,

Sunny

Re: Formula error

Tue, 02 Jun 2015 12:19:42 GMT

the result shows 00:00 everywhere.

Re: Formula error

sunny_talwar — Tue, 02 Jun 2015 12:23:43 GMT

Give this a try and see what happens:

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

Re: Formula error

Tue, 02 Jun 2015 12:28:21 GMT

doesn't work 😞

Still shows 00:00

Re: Formula error

sunny_talwar — Tue, 02 Jun 2015 12:30:49 GMT

Can you show what's the format of [Resolution Time]? Is it a timestamp or in hours field?

Re: Formula error

maxgro — Tue, 02 Jun 2015 12:36:02 GMT

maybe

if([Résolution Time]>(4/24) and [Résolution Time]<(10/24), ...., .....)

Re: Formula error

Tue, 02 Jun 2015 12:37:44 GMT

Above is the screenshot of my table.

The [Resolution Time] is [Résolution en HH/MM/SS] (I am in a french speaking country).

Re: Formula error

sunny_talwar — Tue, 02 Jun 2015 12:44:17 GMT

Try this:

If(Num(Interval#([Resolution Time], 'hh:mm:ss')) > Num(Interval#('4', 'h')) and Num(Interval#([Resolution Time], 'hh:mm:ss')) < Num(Interval#('10', 'h')), Interval(Interval#('6', 'h'), 'hh:mm:ss'), Interval(Interval#('0', 'h'), 'hh:mm:ss'))

Re: Formula error

Tue, 02 Jun 2015 12:48:26 GMT

Still same.. 😞

Re: Formula error

sunny_talwar — Tue, 02 Jun 2015 12:50:51 GMT

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

Best,

Sunny

Re: Formula error

Mon, 08 Jun 2015 06:25:28 GMT

Hi Sunny,

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

Thanks,

Hasvine