Network Days Applying some constraints

[#1]

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

[CELAMBARASAN]

Hi,

     Try like this

     Load

          id,

          col1,

          col2,

          NetworkDays(col2,col1) as datediff

      Resident TableName where id='Error';

Hope this helps

Celambarasan

[#3]

Hi

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

[CELAMBARASAN]

Hi,

     Then you go with the if .

     Load

          id,

          col1,

          col2,

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

      Resident TableName;

Celambarasan

[#5]

Hi

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

Thanks & Regards

Tribhuwan

[CELAMBARASAN]

Hi,

     Can you provide me the structure of your three tables?

Celambarasan

[#7]

Hi

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