Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to find the Networkdays between the two filelds name?

Hi,

Iam New to Qlikview,

I was Tried as following,

Network Days((Date#(In_date)),(Date#(Out_date)))....

Is this way is correct or any changes i have to made?

Please Suggest

Thanks in Advance

Amarnath

3 Replies
tresesco
MVP
MVP

If your dates fields are containing proper dates, you might not require date#(), else if parsing is needed(when the date formats are not similar with app date format), format it with proper format and try like:

Networkdays(date#(In_date, 'DDMMYYYY'), date#(Out_date, 'DDMMYYYY')).

Note: change this ('DDMMYYYY') date format to suit yours.

Anonymous
Not applicable
Author

I was treid this one also but it is not working.

Iam sending my QVW please suggest the Correct solution for this and give the statement for that,y bcz mine is personal edition.

Thanks Tresesco.

arulsettu
Master III
Master III

post your sample data source...