topic Variables as week No in QlikView

topic Variables as week No in QlikView https://community.qlik.com/t5/QlikView/Variables-as-week-No/m-p/1342834#M413487 <HTML><HEAD></HEAD><BODY><P>Does anyone know how to simplify this for me <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR />What I need to do is to check for every week number in the year. (1 to 53)</P><P></P><P></P><P>if(week(CS_MUST_start_FuldDato)<= <SPAN style="color: #ff0000;">8</SPAN>, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=<SPAN style="color: #ff0000;">8</SPAN>,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= <SPAN style="color: #ff0000;">9</SPAN>, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=<SPAN style="color: #ff0000;">9</SPAN>,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 10, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=10,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 11, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=11,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 12, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=12,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 13, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=13,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 14, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=14,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 15, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=15,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 16, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=16,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 17, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=17,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 18, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=18,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P></P><P>ETC.</P><P>.</P><P>.</P><P>.</P><P>.</P><P>.........</P></BODY></HTML> Wed, 19 Apr 2017 14:33:06 GMT fabricius 2017-04-19T14:33:06Z Variables as week No https://community.qlik.com/t5/QlikView/Variables-as-week-No/m-p/1342834#M413487 <HTML><HEAD></HEAD><BODY><P>Does anyone know how to simplify this for me <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR />What I need to do is to check for every week number in the year. (1 to 53)</P><P></P><P></P><P>if(week(CS_MUST_start_FuldDato)<= <SPAN style="color: #ff0000;">8</SPAN>, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=<SPAN style="color: #ff0000;">8</SPAN>,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= <SPAN style="color: #ff0000;">9</SPAN>, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=<SPAN style="color: #ff0000;">9</SPAN>,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 10, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=10,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 11, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=11,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 12, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=12,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 13, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=13,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 14, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=14,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 15, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=15,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 16, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=16,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 17, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=17,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P>-</P><P>if(week(CS_MUST_start_FuldDato)<= 18, </P><P>if(Week(CS_Ønsket_leveringsdato_Dato & '-' & CS_Ønsket_leveringsdato_Month & '-' & CS_Ønsket_leveringsdato_Year)>=18,</P><P>(if(CS_Budget___timer>=40,(5*CS_Dagligt_workload_i_gennemsnit),CS_Budget___timer))</P><P>),0)</P><P></P><P>ETC.</P><P>.</P><P>.</P><P>.</P><P>.</P><P>.........</P></BODY></HTML> Wed, 19 Apr 2017 14:33:06 GMT https://community.qlik.com/t5/QlikView/Variables-as-week-No/m-p/1342834#M413487 fabricius 2017-04-19T14:33:06Z