topic Re: Latest 5 weeks of data in QlikView https://community.qlik.com/t5/QlikView/Latest-5-weeks-of-data/m-p/10590#M774710 <HTML><HEAD></HEAD><BODY><P>Looks like using this i get all the quarters data , i just want to see for Current quarter , basically rolling 5 complete weeks.</P></BODY></HTML> Tue, 01 May 2018 00:22:32 GMT stevejones1 2018-05-01T00:22:32Z Latest 5 weeks of data https://community.qlik.com/t5/QlikView/Latest-5-weeks-of-data/m-p/10586#M774706 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have 2 ranks in my data , rank for latest quarter and rank for latest week , how can i write an expression to show chart for past 5 weeks of data and also is there a way that i could reverse the autonumber?</P><P></P><P>Please help</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Latest-5-weeks-of-data/m-p/10586#M774706 stevejones1 2020-11-25T16:16:04Z Re: Latest 5 weeks of data https://community.qlik.com/t5/QlikView/Latest-5-weeks-of-data/m-p/10587#M774707 <HTML><HEAD></HEAD><BODY><P>what about chart sort the QtrWk dim as expression</P><P></P><P>Descending order of QtrWK</P></BODY></HTML> Thu, 26 Apr 2018 00:22:59 GMT https://community.qlik.com/t5/QlikView/Latest-5-weeks-of-data/m-p/10587#M774707 Anonymous 2018-04-26T00:22:59Z Re: Latest 5 weeks of data https://community.qlik.com/t5/QlikView/Latest-5-weeks-of-data/m-p/10588#M774708 <HTML><HEAD></HEAD><BODY><P>=count({1&lt;Indicator = {'Created'},YrQtrWkRank = {'max(YrQtrWkRank)-5))'},CaseType ={'TS'}&gt;} DISTINCT(CaseNumber))</P><P></P><P>Can someone help me what wrong in this expression , i am trying to shows data for max 5 values</P><P></P><P>Attached the app.</P></BODY></HTML> Thu, 26 Apr 2018 20:20:47 GMT https://community.qlik.com/t5/QlikView/Latest-5-weeks-of-data/m-p/10588#M774708 stevejones1 2018-04-26T20:20:47Z Re: Latest 5 weeks of data https://community.qlik.com/t5/QlikView/Latest-5-weeks-of-data/m-p/10589#M774709 <HTML><HEAD></HEAD><BODY><P>Sorry, I initially uploaded the wrong app.&nbsp; Please try this.</P><P></P><P>=Count({1&lt;CaseType ={'TS'},Indicator = {'Created'},YrQtrWkRank = {"=Rank(YrQtrWkRank)"}&gt;}DISTINCT(CaseNumber))</P></BODY></HTML> Thu, 26 Apr 2018 20:57:46 GMT https://community.qlik.com/t5/QlikView/Latest-5-weeks-of-data/m-p/10589#M774709 jcampbell474 2018-04-26T20:57:46Z Re: Latest 5 weeks of data https://community.qlik.com/t5/QlikView/Latest-5-weeks-of-data/m-p/10590#M774710 <HTML><HEAD></HEAD><BODY><P>Looks like using this i get all the quarters data , i just want to see for Current quarter , basically rolling 5 complete weeks.</P></BODY></HTML> Tue, 01 May 2018 00:22:32 GMT https://community.qlik.com/t5/QlikView/Latest-5-weeks-of-data/m-p/10590#M774710 stevejones1 2018-05-01T00:22:32Z Re: Latest 5 weeks of data https://community.qlik.com/t5/QlikView/Latest-5-weeks-of-data/m-p/10591#M774711 <HTML><HEAD></HEAD><BODY><P>Can someone take a look at this ? </P></BODY></HTML> Tue, 01 May 2018 18:30:46 GMT https://community.qlik.com/t5/QlikView/Latest-5-weeks-of-data/m-p/10591#M774711 stevejones1 2018-05-01T18:30:46Z