topic QTR Function in QlikView https://community.qlik.com/t5/QlikView/QTR-Function/m-p/1306471#M823826 <HTML><HEAD></HEAD><BODY><P>I have expression to pick the expression from Current QTR...so when current qtr starts it will show that particular expense.</P><P></P><P>Is there anyway to show Current QTR expense after 29 days ,once the current Qtr starts...for ex:</P><P></P><P>3 rd qtr start from 7-01-2017.But want to show 2 qtr data until 7-20-2017 and data should switch to&nbsp; rd QTR from 7-21-2017.</P><P></P><P>My data is in the below format.</P><P></P><P>ID&nbsp; Q1-2017&nbsp; Q2 - 2017&nbsp; Q3 - 2017&nbsp; Q4-2017&nbsp; Q1-2018&nbsp; Q2-2018&nbsp; Q3-2018&nbsp;&nbsp; Q4-2018</P><P>1&nbsp;&nbsp;&nbsp; 10000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp; 10000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">50000</SPAN></P><P>2&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30000&nbsp;&nbsp;&nbsp;&nbsp; 10000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">50000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">50000</SPAN></SPAN></P><P>3&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30000&nbsp;&nbsp;&nbsp;&nbsp; 40000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">50000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">50000</SPAN></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;">Here until 7-29 I want to show Q2 - 2017 and from 7-29-2017 I want to show Q3 - 2017 data..</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>Thank you very much</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT apthansh 2020-11-25T16:16:04Z QTR Function https://community.qlik.com/t5/QlikView/QTR-Function/m-p/1306471#M823826 <HTML><HEAD></HEAD><BODY><P>I have expression to pick the expression from Current QTR...so when current qtr starts it will show that particular expense.</P><P></P><P>Is there anyway to show Current QTR expense after 29 days ,once the current Qtr starts...for ex:</P><P></P><P>3 rd qtr start from 7-01-2017.But want to show 2 qtr data until 7-20-2017 and data should switch to&nbsp; rd QTR from 7-21-2017.</P><P></P><P>My data is in the below format.</P><P></P><P>ID&nbsp; Q1-2017&nbsp; Q2 - 2017&nbsp; Q3 - 2017&nbsp; Q4-2017&nbsp; Q1-2018&nbsp; Q2-2018&nbsp; Q3-2018&nbsp;&nbsp; Q4-2018</P><P>1&nbsp;&nbsp;&nbsp; 10000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp; 10000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">50000</SPAN></P><P>2&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30000&nbsp;&nbsp;&nbsp;&nbsp; 10000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">50000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">50000</SPAN></SPAN></P><P>3&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30000&nbsp;&nbsp;&nbsp;&nbsp; 40000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">50000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">50000</SPAN></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;">Here until 7-29 I want to show Q2 - 2017 and from 7-29-2017 I want to show Q3 - 2017 data..</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>Thank you very much</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/QTR-Function/m-p/1306471#M823826 apthansh 2020-11-25T16:16:04Z