topic Re: Expression and week aggregation help in QlikView https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914244#M317156 <HTML><HEAD></HEAD><BODY><P>any help..</P></BODY></HTML> Thu, 06 Aug 2015 18:23:33 GMT Anonymous 2015-08-06T18:23:33Z Expression and week aggregation help https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914235#M317147 <HTML><HEAD></HEAD><BODY><P>I need to put a week bucket slider upto four weeks, when the slider is on 1st week the week total expression should calculate only one week total, when we move the slider to two weeks it should calculate the total for 2 weeks... so on.. Please see attached screen shot and attached QVW file.. Thanks for your help in advance.<IMG alt="Week issue.PNG" class="jive-image image-1" src="/legacyfs/online/95251_Week issue.PNG" style="height: 305px; width: 620px;" /></P></BODY></HTML> Thu, 06 Aug 2015 15:23:04 GMT https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914235#M317147 Anonymous 2015-08-06T15:23:04Z Re: Expression and week aggregation help https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914236#M317148 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/171708">sunindia</A>‌ <A href="https://community.qlik.com/qlik-users/120618">MRKachhiaIMP</A>‌</P></BODY></HTML> Thu, 06 Aug 2015 15:26:31 GMT https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914236#M317148 Anonymous 2015-08-06T15:26:31Z Re: Expression and week aggregation help https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914237#M317149 <HTML><HEAD></HEAD><BODY><P>What happens with the other columns when you select 2 weeks for example? do they change accordingly or should ignore the week selection?</P><P></P><P>Regards</P></BODY></HTML> Thu, 06 Aug 2015 15:33:22 GMT https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914237#M317149 maximiliano_vel 2015-08-06T15:33:22Z Re: Expression and week aggregation help https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914238#M317150 <HTML><HEAD></HEAD><BODY><P>Hi Vinay,</P><P>see attachment.</P><P>Regards</P></BODY></HTML> Thu, 06 Aug 2015 15:39:32 GMT https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914238#M317150 antoniotiman 2015-08-06T15:39:32Z Re: Expression and week aggregation help https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914239#M317151 <HTML><HEAD></HEAD><BODY><P>Thank you Velez and Antonio for your quick response, i will update an excel sheet with how the output should look like..</P></BODY></HTML> Thu, 06 Aug 2015 15:43:37 GMT https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914239#M317151 Anonymous 2015-08-06T15:43:37Z Re: Expression and week aggregation help https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914240#M317152 <HTML><HEAD></HEAD><BODY><P>This is how my out should come like.. see attached excel sheet.. Thank you for your help </P></BODY></HTML> Thu, 06 Aug 2015 15:51:38 GMT https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914240#M317152 Anonymous 2015-08-06T15:51:38Z Re: Expression and week aggregation help https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914241#M317153 <HTML><HEAD></HEAD><BODY><P>Vinay,</P><P>see attachment.</P><P>You can add further If() according number max of weeks</P><P>Regards</P></BODY></HTML> Thu, 06 Aug 2015 16:30:52 GMT https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914241#M317153 antoniotiman 2015-08-06T16:30:52Z Re: Expression and week aggregation help https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914242#M317154 <HTML><HEAD></HEAD><BODY><P>hi Antonio,</P><P></P><P>Please see below screen shot<IMG alt="Week issue.PNG" class="jive-image image-1" src="/legacyfs/online/95256_Week issue.PNG" style="height: 287px; width: 620px;" /></P></BODY></HTML> Thu, 06 Aug 2015 18:15:39 GMT https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914242#M317154 Anonymous 2015-08-06T18:15:39Z Re: Expression and week aggregation help https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914243#M317155 <HTML><HEAD></HEAD><BODY><P>See Column 'Week Total New'</P></BODY></HTML> Thu, 06 Aug 2015 18:23:29 GMT https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914243#M317155 antoniotiman 2015-08-06T18:23:29Z Re: Expression and week aggregation help https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914244#M317156 <HTML><HEAD></HEAD><BODY><P>any help..</P></BODY></HTML> Thu, 06 Aug 2015 18:23:33 GMT https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914244#M317156 Anonymous 2015-08-06T18:23:33Z Re: Expression and week aggregation help https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914245#M317157 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Antonio <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P></BODY></HTML> Thu, 06 Aug 2015 18:31:24 GMT https://community.qlik.com/t5/QlikView/Expression-and-week-aggregation-help/m-p/914245#M317157 Anonymous 2015-08-06T18:31:24Z