topic Set analysis in script in QlikView

Set analysis in script

Sun, 22 Jan 2012 21:41:37 GMT

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

Set analysis in script

Sun, 22 Jan 2012 21:44:37 GMT

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!

Set analysis in script

Sun, 22 Jan 2012 21:47:14 GMT

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

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

Set analysis in script

Sun, 22 Jan 2012 22:18:59 GMT

Thanks Matpj .

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

Set analysis in script

vijay_iitkgp — Mon, 23 Jan 2012 06:10:55 GMT

Hi Pravenk,

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

Vijay