topic Re: show next weeks with zero in QlikView https://community.qlik.com/t5/QlikView/show-next-weeks-with-zero/m-p/17031#M2829 <HTML><HEAD></HEAD><BODY><P>hi, my dimension has 52 weeks of the year the problem lies in sales, as we have not reached the following weeks I still can not show that period</P></BODY></HTML> Mon, 29 Jan 2018 21:17:39 GMT gr_eldred 2018-01-29T21:17:39Z show next weeks with zero https://community.qlik.com/t5/QlikView/show-next-weeks-with-zero/m-p/17029#M2827 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">show zeros forward</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">I have a pivot table object that shows the weeks of the first quarter of the year. We are in week four so nothing shows the weeks of the 4 weeks but I need to show the next weeks of the quarter even with a zero. Is this possible to do ?</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Currently my object is like that?</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><IMG alt="semanas1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/191759_semanas1.png" style="height: auto;" /><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">I need this</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><IMG alt="semanas2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/191760_semanas2.png" style="height: 110px; width: 620px;" /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Can somebody help me?</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P></P></BODY></HTML> Mon, 29 Jan 2018 19:45:07 GMT https://community.qlik.com/t5/QlikView/show-next-weeks-with-zero/m-p/17029#M2827 gr_eldred 2018-01-29T19:45:07Z Re: show next weeks with zero https://community.qlik.com/t5/QlikView/show-next-weeks-with-zero/m-p/17030#M2828 <HTML><HEAD></HEAD><BODY><P>Just create 'dummy' dimmension with all the weeks you want to show. Autogenerate function may be handy.</P><P>Tomasz</P></BODY></HTML> Mon, 29 Jan 2018 19:56:18 GMT https://community.qlik.com/t5/QlikView/show-next-weeks-with-zero/m-p/17030#M2828 tomasz_tru 2018-01-29T19:56:18Z Re: show next weeks with zero https://community.qlik.com/t5/QlikView/show-next-weeks-with-zero/m-p/17031#M2829 <HTML><HEAD></HEAD><BODY><P>hi, my dimension has 52 weeks of the year the problem lies in sales, as we have not reached the following weeks I still can not show that period</P></BODY></HTML> Mon, 29 Jan 2018 21:17:39 GMT https://community.qlik.com/t5/QlikView/show-next-weeks-with-zero/m-p/17031#M2829 gr_eldred 2018-01-29T21:17:39Z Re: show next weeks with zero https://community.qlik.com/t5/QlikView/show-next-weeks-with-zero/m-p/17032#M2830 <HTML><HEAD></HEAD><BODY><P>My misunderstanding. It would work in Sense so there must be an option somewhere in QV <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Mon, 29 Jan 2018 21:34:05 GMT https://community.qlik.com/t5/QlikView/show-next-weeks-with-zero/m-p/17032#M2830 tomasz_tru 2018-01-29T21:34:05Z Re: show next weeks with zero https://community.qlik.com/t5/QlikView/show-next-weeks-with-zero/m-p/17033#M2831 <HTML><HEAD></HEAD><BODY><P>I use Qlikview</P></BODY></HTML> Mon, 29 Jan 2018 21:42:43 GMT https://community.qlik.com/t5/QlikView/show-next-weeks-with-zero/m-p/17033#M2831 gr_eldred 2018-01-29T21:42:43Z