topic Re: Cumulative up until a certain point in QlikView https://community.qlik.com/t5/QlikView/Cumulative-up-until-a-certain-point/m-p/304108#M112424 <HTML><HEAD></HEAD><BODY><P> hei attach is an example </P><P></P><P>heav a look may be it helps you </P></BODY></HTML> Wed, 25 Jan 2012 08:31:55 GMT lironbaram 2012-01-25T08:31:55Z Cumulative up until a certain point https://community.qlik.com/t5/QlikView/Cumulative-up-until-a-certain-point/m-p/304107#M112423 <HTML><HEAD></HEAD><BODY><P>Hey all,</P><P></P><P>I want to have a line graph with as dimensions the week of the year and with three expressions:</P><P>- sales from 2010</P><P>- sales from 2011</P><P>- sales from 2012</P><P></P><P>The first two should be 'full accumulation' but the last one should stop in the current week.</P><P></P><P>When I would create this the logical way then I have a horizontal line for the last expression from the current week untill the end of the year.</P><P></P><P>How do I solve this?</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 25 Jan 2012 08:24:42 GMT https://community.qlik.com/t5/QlikView/Cumulative-up-until-a-certain-point/m-p/304107#M112423 2012-01-25T08:24:42Z Re: Cumulative up until a certain point https://community.qlik.com/t5/QlikView/Cumulative-up-until-a-certain-point/m-p/304108#M112424 <HTML><HEAD></HEAD><BODY><P> hei attach is an example </P><P></P><P>heav a look may be it helps you </P></BODY></HTML> Wed, 25 Jan 2012 08:31:55 GMT https://community.qlik.com/t5/QlikView/Cumulative-up-until-a-certain-point/m-p/304108#M112424 lironbaram 2012-01-25T08:31:55Z Re: Cumulative up until a certain point https://community.qlik.com/t5/QlikView/Cumulative-up-until-a-certain-point/m-p/304109#M112425 <HTML><HEAD></HEAD><BODY><P> Ok Thank you Baram, so the solution was to have two dimensions: one for the year and one for the week and to have only one expression.</P></BODY></HTML> Wed, 25 Jan 2012 09:11:30 GMT https://community.qlik.com/t5/QlikView/Cumulative-up-until-a-certain-point/m-p/304109#M112425 2012-01-25T09:11:30Z Cumulative up until a certain point https://community.qlik.com/t5/QlikView/Cumulative-up-until-a-certain-point/m-p/304110#M112426 <HTML><HEAD></HEAD><BODY><P> yes </P><P>as rule of thumb </P><P>i'll try to use the simpler solution there is in qlikview</P><P>the model would work faster that way</P></BODY></HTML> Wed, 25 Jan 2012 09:21:46 GMT https://community.qlik.com/t5/QlikView/Cumulative-up-until-a-certain-point/m-p/304110#M112426 lironbaram 2012-01-25T09:21:46Z