Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis in script

Hello .

Since i am new in qlik view , can any one help me to guide if we can use set analysis in script .

if yes , how to exculde the weekends .

Scenario1 :- I want to calculate no of man hours spend in weekdays for a month

If is there other solutions to find this that is also fine ..

Many thanks for help in advance .

Regards

Pravenk

1 Solution

Accepted Solutions
Not applicable
Author

Have you played with the NETWORKDAYS function?This allows you to put a start/end date in and it returns the number of working days in the range.  You might be able to incorporate that into your calculations.  hope it helps!

View solution in original post

4 Replies
Not applicable
Author

Have you played with the NETWORKDAYS function?This allows you to put a start/end date in and it returns the number of working days in the range.  You might be able to incorporate that into your calculations.  hope it helps!

Not applicable
Author

Thanks a lot for quick answer . I will try for this .

Could you please guide me if we can use set analysis in script . ????

Not applicable
Author

Thanks Matpj .

http://community.qlik.com/message/78884#78884  This is answer of my second question .

vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi Pravenk,

You can not use set analysis in script. You can use it only at front end.

Vijay