Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
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!
Thanks a lot for quick answer . I will try for this .
Could you please guide me if we can use set analysis in script . ????
Thanks Matpj .
http://community.qlik.com/message/78884#78884 This is answer of my second question .
Hi Pravenk,
You can not use set analysis in script. You can use it only at front end.
Vijay