topic Re: 9 quarters excluding nulls in QlikView https://community.qlik.com/t5/QlikView/9-quarters-excluding-nulls/m-p/1425321#M809466 <HTML><HEAD></HEAD><BODY><P>I'm sure someone can help you, but its nearly impossible to do so on the limited information you have provided. </P><P></P><P><A href="https://community.qlik.com/docs/DOC-2380">Qlik Community Tip: How to Get Answers to Your Post</A></P><P><A href="https://community.qlik.com/docs/DOC-7538">Qlik Community Tip: Posting Successful Discussion Threads</A></P></BODY></HTML> Tue, 10 Oct 2017 12:43:22 GMT jonathandienst 2017-10-10T12:43:22Z 9 quarters excluding nulls https://community.qlik.com/t5/QlikView/9-quarters-excluding-nulls/m-p/1425320#M809465 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P>I have a calculated dimension as if(quarter = 'Q',null(),quarter). Which is displaying 11 quarters from 2017Q2 to 2019Q4. I want to display only first 10 quarters like 2017Q2&nbsp; as P0 to P9 ie 2019 Q4. I tried with using agg function but its not returning any quarters. Can someone help me ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/9-quarters-excluding-nulls/m-p/1425320#M809465 dandaanilreddy 2020-11-25T16:16:04Z Re: 9 quarters excluding nulls https://community.qlik.com/t5/QlikView/9-quarters-excluding-nulls/m-p/1425321#M809466 <HTML><HEAD></HEAD><BODY><P>I'm sure someone can help you, but its nearly impossible to do so on the limited information you have provided. </P><P></P><P><A href="https://community.qlik.com/docs/DOC-2380">Qlik Community Tip: How to Get Answers to Your Post</A></P><P><A href="https://community.qlik.com/docs/DOC-7538">Qlik Community Tip: Posting Successful Discussion Threads</A></P></BODY></HTML> Tue, 10 Oct 2017 12:43:22 GMT https://community.qlik.com/t5/QlikView/9-quarters-excluding-nulls/m-p/1425321#M809466 jonathandienst 2017-10-10T12:43:22Z