Regardin NetWorkDays() function

sarfaraz_sheikh — Mon, 08 Dec 2014 07:31:10 GMT

Hi All,

I want to calculate the diffrence of days between receive_date and create_date_system ....suppose for ex.

Receive_date = 18-OCT-2014 and

Create_date_system = 20-OCT-2014

Result = 2

i.e i should get 2 as result and to achieve this i used NetWorkDays(Receive_date ,Create_Date_System) function as well but still i am not getting as expected output ..nothing is appearing in the result column;;

below is my data: help me for needful solution

Inward_No , Create_Date , Receive_Date, Create_Date_System

IN1747446, 14-OCT-10, 14-OCT-10, 15-OCT-10,
IN1747505, 14-OCT-10, 15-OCT-10, 16-OCT-10,
IN1747462, 14-OCT-10, 14-OCT-10, 17-OCT-10,
IN1749635, 14-OCT-10, 14-OCT-10, 17-OCT-10,
IN1749685, 14-OCT-10, 15-OCT-10, 16-OCT-10,
IN1750030, 14-OCT-10, 14-OCT-10, 14-OCT-10,
IN1750844, 14-OCT-10, 16-OCT-10, 18-OCT-10,
IN1750852, 14-OCT-10, 14-OCT-10, 14-OCT-10,
IN1751131, 14-OCT-10, 14-OCT-10, 16-OCT-10,
IN1751225, 14-OCT-10, 17-OCT-10, 14-OCT-10,
IN1747596, 14-OCT-10, 14-OCT-10, 16-OCT-10,
IN1749671, 14-OCT-10, 18-OCT-10, 20-OCT-10,
IN1747512, 14-OCT-10, 14-OCT-10, 14-OCT-10,
IN1750063, 14-OCT-10, 19-OCT-10, 21-OCT-10,
IN1749916, 14-OCT-10, 20-OCT-10, 14-OCT-10,
IN1750267, 14-OCT-10, 14-OCT-10, 14-OCT-10,
IN4423581, 14-OCT-11, 21-OCT-11, 23-OCT-11,

Regards

Sarfaraz Sheikh

Re: Regardin NetWorkDays() function

ashwanin — Mon, 08 Dec 2014 08:01:49 GMT

Hi Sarfaraz,

Date format in the above example is not as DD-MMM-YY. It seems, but in actual it doesn't.

Once you get it corrected the Networkdays formula automatically will work.

See attached QVW with your date format as mentioned above and in correct format.

topic Regardin NetWorkDays() function in QlikView

Regardin NetWorkDays() function

Re: Regardin NetWorkDays() function