Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Network Days Applying some constraints

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

6 Replies

Network Days Applying some constraints

Hi,

     Try like this

     Load

          id,

          col1,

          col2,

          NetworkDays(col2,col1) as datediff

      Resident TableName where id='Error';

Hope this helps

Celambarasan

Not applicable

Re: Network Days Applying some constraints

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

Re: Network Days Applying some constraints

Hi,

     Then you go with the if .

   

     Load

          id,

          col1,

          col2,

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

      Resident TableName;

Celambarasan

Not applicable

Re: Network Days Applying some constraints

Hi

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

Hi,

     Can you provide me the structure of your three tables?

Celambarasan

Not applicable

Re: Network Days Applying some constraints

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

Community Browser