topic Re: Error in expression in QlikView

Error in expression

master_student — Wed, 25 May 2016 14:33:53 GMT

Hi,

There 's erros in this expression. please help me to find out those errors :

=if(CONGE='Y',HR_CONGE,Hour(Date(if(isnull(PRESENCE),0,PRESENCE/1440),"hh:mm:ss")))&'H:' &Minute(Date(if(isnull(PRESENCE),0,PRESENCE/1440),"hh:mm:ss"))

&'Min'

Thanks

Re: Error in expression

sunny_talwar — Wed, 25 May 2016 14:39:08 GMT

May be this:

=If(CONGE='Y',

HR_CONGE,

Floor(If(IsNull(PRESENCE), 0, PRESENCE/1440)) & 'H:' &

Floor(If(IsNull(PRESENCE), 0, PRESENCE/86400)) & 'Min')

Re: Error in expression

Gysbert_Wassenaar — Wed, 25 May 2016 14:42:43 GMT

Make sure to use single quotes instead of double quotes around the format string. Actually you can leave out the entire Date() function. It's unnecessary since you use the Hour and Minute functions on the result.

If that doesn't solve the problem then please post a small qlikview document that demonstrates the issue.

Re: Error in expression

miguelbraga — Wed, 25 May 2016 14:44:38 GMT

Hi there,

Try this:

(

CONGE='Y',

HR_CONGE,

timestamp

(

isnull(PRESENCE),

PRESENCE/1440

"hh"

)

'H:'

timestamp(if(isnull(PRESENCE),0,PRESENCE/1440),"mm")

'Min'

I think this will be without errors

Regards,

Re: Error in expression

miguelbraga — Wed, 25 May 2016 14:46:13 GMT

What kind of output does PRESENCE give?

Can you please share with us a QVW or a sample of your data or even a screenshot of it?

Regards,

Re: Error in expression

master_student — Wed, 25 May 2016 15:31:40 GMT

miguelbraga‌ to be honest I don't understand well this expression but the result is duréé 08:00

see below a part of the concerned table :

LOCATION	TIME	CONGE	HR_CONGE	TOT_TIME	PRESENCE
CONGE	0	Y	8	8h0min	480

could you explain it to me

Re: Error in expression

miguelbraga — Wed, 25 May 2016 15:52:33 GMT

Your field PRESENCE is the number of seconds of a specific LOCATION.

The TOT_TIME gives you almost the answer you're looking for. Just use this:

=replace(replace(TOT_TIME, 'h', 'H:'), 'min', 'Min')

This will give you the results in your chart

Regards,

Re: Error in expression

master_student — Fri, 27 May 2016 11:42:13 GMT

Hi, I need to count the empty cases I did like that and didn't work :

if ([MSISDN_APPELANT] ='-',count(MSISDN_APPELANT))

do you have any idea?

Thanks

Re: Error in expression

rubenmarin — Fri, 27 May 2016 12:35:57 GMT

Hi, In that expression you are searching for the value '-', is this value stored in the load of data? Or can be that '-' meant the null values QV draws? If it's a null value maybe with NullCount(MSISDN_APPELANT)

Re: Error in expression

master_student — Fri, 27 May 2016 23:20:44 GMT

it works with NullCount(MSISDN_APPELANT)

Thanks