Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Set analysis in script

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!

4 Replies
Not applicable

Set analysis in script

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

Set analysis in script

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

Set analysis in script

Thanks Matpj .

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

vijay_iitkgp
Valued Contributor

Set analysis in script

Hi Pravenk,

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

Vijay

Community Browser