topic Re: Network Days Applying some constraints in QlikView

Network Days Applying some constraints

Fri, 09 Mar 2012 03:56:55 GMT

Hi Guys

I have a table having three columns. Two columns having data type 'date' and third column is 'id'. I want to use the function NetworkDays on this two date columns and applying constraint on third column id. Is there any work around to achieve this.

Equivalent sql :- select date_diff(col1,col2) where id = "Error".

Thanks in advance

Network Days Applying some constraints

CELAMBARASAN — Fri, 09 Mar 2012 04:28:19 GMT

Hi,

Try like this

Load

id,

col1,

col2,

NetworkDays(col2,col1) as datediff

Resident TableName where id='Error';

Hope this helps

Celambarasan

Re: Network Days Applying some constraints

Fri, 09 Mar 2012 04:44:57 GMT

I have four different type of ids so I would have to add four load statements. I don’t think it would be great for my qlikview data load.

Actually I wanted to achieve this in expressions. Is there any idea you can give to me.

Thanks & Regards

Tribhuwan

Re: Network Days Applying some constraints

CELAMBARASAN — Fri, 09 Mar 2012 05:07:59 GMT

Hi,

Then you go with the if .

Load

id,

col1,

col2,

if(id='Error',NetworkDays(col2,col1)) as datediff

Resident TableName;

Celambarasan

Re: Network Days Applying some constraints

Fri, 09 Mar 2012 05:27:00 GMT

id,col1, col2 are coming from three different tables. Can you please provide me the syntax of join.

Thanks & Regards

Tribhuwan

Re: Network Days Applying some constraints

CELAMBARASAN — Fri, 09 Mar 2012 05:29:19 GMT

Hi,

Can you provide me the structure of your three tables?

Celambarasan

Re: Network Days Applying some constraints

Fri, 09 Mar 2012 05:41:25 GMT

I need more information from development team. I will get back to you after getting this info.

Thanks for your valuable time and help

Thanks & Regards

Tribhuwan