topic Error in Expression in QlikView

Error in Expression

Tue, 29 May 2012 20:44:47 GMT

Good day,

I am trying to use this expression below, but it shows me that there is an error in the expression.

What i am trying is really simple, i want that QV count the networkdays between TS.CorrectOne and Date_Time1 that are equal or higher than 5.

count(distinct if(networkdays(avg(TS.CorrectOne),avg(Date_Time1)) >= 5 , TS.Voyage))

Is there any other posibility or am I doing something wrong?

Just for information, these two fields are not in the same table.

Regards,

Wed, 30 May 2012 11:56:59 GMT

Any sugestion my friends?

Rgds,

Jorge

Sokkorn — Wed, 30 May 2012 12:09:45 GMT

Hi Jorge,

Try this if(networkdays(avg(TS.CorrectOne),avg(Date_Time1)) >= 5 , COUNT(DISTINCT TS.Voyage))

Regards,

Sokkorn

Wed, 30 May 2012 12:25:13 GMT

Tks Sokkorn, but I already try this expression, the problem with this is that it gives me the total number and without the condition.

I am here trying to think in another condition expression, but i can't find any.

I will try to join these two fields into one table and create this expression in script, probably it will work.

Wed, 30 May 2012 14:03:41 GMT

I found it, i use this formula and worked:

count(aggr(if(networkdays(avg(TS.CorrectOne),avg(Date_Time1)) >= 5,Count(distinct TS.Voyage)),Month,TS.Voyage))

Rgds,

Jorge