topic Assign working days to months in QlikView https://community.qlik.com/t5/QlikView/Assign-working-days-to-months/m-p/4663#M792374 <HTML><HEAD></HEAD><BODY><P>I have a pivot table in which I have months(dimension) attributed to each work cycle. My months already change dynamically by selecting a work cycle from the multi-box. Is there any way I can assign the working days values to each month, in an expression, without using about 12 nested ifs? </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Assign working days to months https://community.qlik.com/t5/QlikView/Assign-working-days-to-months/m-p/4663#M792374 <HTML><HEAD></HEAD><BODY><P>I have a pivot table in which I have months(dimension) attributed to each work cycle. My months already change dynamically by selecting a work cycle from the multi-box. Is there any way I can assign the working days values to each month, in an expression, without using about 12 nested ifs? </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Assign-working-days-to-months/m-p/4663#M792374 Anonymous 2020-11-25T16:16:04Z Re: Assign working days to months https://community.qlik.com/t5/QlikView/Assign-working-days-to-months/m-p/4664#M792376 <HTML><HEAD></HEAD><BODY><P>I suggest to do this assigning within the script in a master-calendar with something:</P><P></P><P>if(weekday(Date) &lt; 5, 1, 0) as WorkingDay</P><P></P><P>and this new field could be easily queried with somehing like: sum(WorkingDay)</P><P></P><P>Also possible are calculations with networkingdays() within the UI.</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 22 Jan 2018 12:14:01 GMT https://community.qlik.com/t5/QlikView/Assign-working-days-to-months/m-p/4664#M792376 marcus_sommer 2018-01-22T12:14:01Z Re: Assign working days to months https://community.qlik.com/t5/QlikView/Assign-working-days-to-months/m-p/4665#M792379 <HTML><HEAD></HEAD><BODY><P>Thanks for the idea </P></BODY></HTML> Mon, 22 Jan 2018 12:22:21 GMT https://community.qlik.com/t5/QlikView/Assign-working-days-to-months/m-p/4665#M792379 Anonymous 2018-01-22T12:22:21Z