topic Re: Quarter name in expression in QlikView https://community.qlik.com/t5/QlikView/Quarter-name-in-expression/m-p/1370705#M419002 <HTML><HEAD></HEAD><BODY><P>If intented as above, would suggest to combine suggestions made by Fer Fer and Camillo and combine with a DUAL-function. Thus Quarters will be sorted:</P><P></P><P>=DUAL('Q' &amp; Ceil(Month(MyDate)/3) &amp; '-' &amp; Year(MyDate) , QUARTERNAME(MyDate))</P><P></P><P>HTH Peter</P></BODY></HTML> Thu, 29 Jun 2017 07:00:07 GMT prieper 2017-06-29T07:00:07Z Quarter name in expression https://community.qlik.com/t5/QlikView/Quarter-name-in-expression/m-p/1370701#M418998 <HTML><HEAD></HEAD><BODY><P>hii</P><P></P><P>i have date column from which i want to extract Quarter in QQ/YYYY format and to be used in an expression in a line chart..Will someone please guide.</P><P></P><P>Note: the chart is functioning correctly for Year with expression = (Date Column Name) with the expression number format as YYYY.</P></BODY></HTML> Wed, 28 Jun 2017 08:47:34 GMT https://community.qlik.com/t5/QlikView/Quarter-name-in-expression/m-p/1370701#M418998 2017-06-28T08:47:34Z Re: Quarter name in expression https://community.qlik.com/t5/QlikView/Quarter-name-in-expression/m-p/1370702#M418999 <HTML><HEAD></HEAD><BODY><P>can you please provide an example?</P></BODY></HTML> Wed, 28 Jun 2017 15:26:38 GMT https://community.qlik.com/t5/QlikView/Quarter-name-in-expression/m-p/1370702#M418999 prieper 2017-06-28T15:26:38Z Re: Quarter name in expression https://community.qlik.com/t5/QlikView/Quarter-name-in-expression/m-p/1370703#M419000 <HTML><HEAD></HEAD><BODY><P>Just try with QuarterName(YourDate).</P><P>Can You provide some more details?</P></BODY></HTML> Wed, 28 Jun 2017 15:53:31 GMT https://community.qlik.com/t5/QlikView/Quarter-name-in-expression/m-p/1370703#M419000 rospigliosi 2017-06-28T15:53:31Z Re: Quarter name in expression https://community.qlik.com/t5/QlikView/Quarter-name-in-expression/m-p/1370704#M419001 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>1 Example:</P><P></P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">='Q' &amp; </SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: blue;">Ceil</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: blue;">Month</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: blue;">Today</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">())/3) &amp; '-' &amp; </SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: blue;">Year</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">(</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: blue;">Today</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Arial',sans-serif; color: black;">()) </SPAN></P></BODY></HTML> Wed, 28 Jun 2017 15:55:36 GMT https://community.qlik.com/t5/QlikView/Quarter-name-in-expression/m-p/1370704#M419001 el_aprendiz111 2017-06-28T15:55:36Z Re: Quarter name in expression https://community.qlik.com/t5/QlikView/Quarter-name-in-expression/m-p/1370705#M419002 <HTML><HEAD></HEAD><BODY><P>If intented as above, would suggest to combine suggestions made by Fer Fer and Camillo and combine with a DUAL-function. Thus Quarters will be sorted:</P><P></P><P>=DUAL('Q' &amp; Ceil(Month(MyDate)/3) &amp; '-' &amp; Year(MyDate) , QUARTERNAME(MyDate))</P><P></P><P>HTH Peter</P></BODY></HTML> Thu, 29 Jun 2017 07:00:07 GMT https://community.qlik.com/t5/QlikView/Quarter-name-in-expression/m-p/1370705#M419002 prieper 2017-06-29T07:00:07Z