topic Re: How to get continuous fiscalweeks? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602045#M1112366 <HTML><HEAD></HEAD><BODY><P>Please any help as this is very very urgent to me</P></BODY></HTML> Tue, 18 Feb 2014 16:49:19 GMT 2014-02-18T16:49:19Z How to get continuous fiscalweeks? https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602038#M1112347 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have dimensions and exression as below in bar chart</P><P></P><P>Dimension1: =IF(FiscalWeekSerial&gt;=$(curFiscalWeekSeq)-4,FiscalWeek)</P><P></P><P>Dimension2: Staff</P><P></P><P>Expression: COUNT({&lt;DateDue={'&gt;$(=Today())'}&gt;}DISTINCT(StudentID))</P><P></P><P>So, this will show the data as weeks on horizotal axes. s, it will show weeks as 31,32,33,34. Now we are under 34 fiscal week.</P><P></P><P>My user wants to see starting only from currentfiscalweek and continuing. i,e</P><P></P><P>34,35,36,37. Is that possible. I changed the dimension as below</P><P></P><P>IF(FiscalWeekSerial&gt;$(curFiscalWeekSeq)-1,FiscalWeek)</P><P></P><P>and it is showing only week 34. But I need to show 34,35,36,37.</P><P></P><P>Is it possible? if so can anyone suggest me please.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 18 Feb 2014 15:35:20 GMT https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602038#M1112347 2014-02-18T15:35:20Z Re: How to get continuous fiscalweeks? https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602039#M1112349 <HTML><HEAD></HEAD><BODY><P>How can I display the next following weeks<BR />?</P></BODY></HTML> Tue, 18 Feb 2014 15:54:43 GMT https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602039#M1112349 2014-02-18T15:54:43Z Re: How to get continuous fiscalweeks? https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602040#M1112352 <HTML><HEAD></HEAD><BODY><P>Dear Amelia,</P><P></P><P>If you want to show data for Previous 4 weeks starting from current week... you can use something like below...</P><P>SUM({&lt;Week = {'&lt;=$(=Week(Today())) &gt; $(=Week(Today())-4) '}&gt;}Sales)</P><P></P><P>If you want to show data for Next 4 weeks starting from current week... you can use something like below...</P><P>SUM({&lt;Week = {'&gt;=$(=Week(Today())) &lt; $(=Week(Today())-4) '}&gt;}Sales)</P></BODY></HTML> Tue, 18 Feb 2014 15:54:43 GMT https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602040#M1112352 MK_QSL 2014-02-18T15:54:43Z Re: How to get continuous fiscalweeks? https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602041#M1112356 <HTML><HEAD></HEAD><BODY><P>Thanks. I would need to show the weeks display on the horizotal axes. Is it possible. Can you please change my exression please.</P></BODY></HTML> Tue, 18 Feb 2014 15:56:34 GMT https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602041#M1112356 2014-02-18T15:56:34Z Re: How to get continuous fiscalweeks? https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602042#M1112361 <HTML><HEAD></HEAD><BODY><P>I tried many ways but no luck Please any solution?</P></BODY></HTML> Tue, 18 Feb 2014 16:16:01 GMT https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602042#M1112361 2014-02-18T16:16:01Z Re: How to get continuous fiscalweeks? https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602043#M1112364 <HTML><HEAD></HEAD><BODY><P>Use dimension as Week</P><P>Tick Suppress When Value is Null in Dimension Tab</P><P>and use my given expressions.</P></BODY></HTML> Tue, 18 Feb 2014 16:17:39 GMT https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602043#M1112364 MK_QSL 2014-02-18T16:17:39Z Re: How to get continuous fiscalweeks? https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602044#M1112365 <HTML><HEAD></HEAD><BODY><P>Thanks. I can not use SUM. I don't have issue with expression . Only the issue is with dimension. Is there any change do I need to make. Now I have another dimensin also.</P><P></P><P>Dim1:=IF(FiscalWeekSerial&gt;=$(curFiscalWeekSeq)-4,FiscalWeek)</P><P></P><P>Dim2: Staff</P><P></P><P>Dim3: Department.</P><P></P><P>Actually I have to show how many students are in progress(overdue) with the weeks based on DateDue</P></BODY></HTML> Tue, 18 Feb 2014 16:23:14 GMT https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602044#M1112365 2014-02-18T16:23:14Z Re: How to get continuous fiscalweeks? https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602045#M1112366 <HTML><HEAD></HEAD><BODY><P>Please any help as this is very very urgent to me</P></BODY></HTML> Tue, 18 Feb 2014 16:49:19 GMT https://community.qlik.com/t5/QlikView/How-to-get-continuous-fiscalweeks/m-p/602045#M1112366 2014-02-18T16:49:19Z