topic Re: IF Expression is not working well in QlikView

IF Expression is not working well

Mon, 05 Oct 2015 16:57:09 GMT

Hi,

can anyone explain me why in my example the if clause is not working? I think the problem is maybe in the time format. But I working on it over 3 hours and I can#t find the answer...

What I#am doing wrong?

The result must be INSIDE for both and not OUTSIDE

I hope anyone can help me ... THanks

Re: IF Expression is not working well

Clever_Anjos — Mon, 05 Oct 2015 17:05:10 GMT

Your application is full of invalid expressions, is it correct?

Re: IF Expression is not working well

Mon, 05 Oct 2015 17:10:51 GMT

Oh ya, I think this is better...

Re: IF Expression is not working well

Clever_Anjos — Mon, 05 Oct 2015 17:20:27 GMT

Could you kindly guide me where should I check your "IF" that isn´t working?

Re: IF Expression is not working well

Mon, 05 Oct 2015 17:27:48 GMT

Take my new File. The script is important! When you look at the if clause you will see that for ID 1 the min time value is 05:00:00.

And now the if clause is...

If( 05:00:00 >= 05:00:00 AND 05:00:00 < 05:30:00, Inside, Outside )

The result must be Inside but QlikView says Outside. I don't know why...

Re: IF Expression is not working well

Clever_Anjos — Mon, 05 Oct 2015 17:33:11 GMT

Could you describe your Business rule?

Re: IF Expression is not working well

Clever_Anjos — Mon, 05 Oct 2015 17:43:38 GMT

I think this should solve your needs

if(frac(MinF) >= MakeTime(Hour(MinF)) AND frac(MinF) < MakeTime(Hour(MinF),30) , 'Inside', 'Outside' ) as StartGK

Be carefull when using timestamp, your Minf was formated as hh:mm:ss but actually still has the date inside it

Re: IF Expression is not working well

Mon, 05 Oct 2015 17:50:28 GMT

Oh yess, thank you. But why is the Minf not formated as time? I use time()... And frac is cutting the date?

Re: IF Expression is not working well

Clever_Anjos — Mon, 05 Oct 2015 17:57:48 GMT

frac() get rid of date part

Try this at script and change the format verifying the differences

LOAD

date(now()) as date1,

date(floor(now())) as date2,

time(now()) as time1,

time(frac(now())) as time2

autogenerate 1;