topic Re: How to get Distinct Year in QlikView https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077782#M359461 <HTML><HEAD></HEAD><BODY><P>In list box to taken the distint values only</P></BODY></HTML> Thu, 03 Mar 2016 10:09:25 GMT Anonymous 2016-03-03T10:09:25Z How to get Distinct Year https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077773#M359452 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>With below expression im not getting distinct year, how to avoid duplicate years while loading script</P><P>Any suggestion or modifications on below expression </P><P></P><P> =Date(Mid([MTRC_FCT_DT],1,8),'YYYY') as Year</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/116728_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Best Regards,</P><P>Niranjan</P></BODY></HTML> Thu, 03 Mar 2016 06:06:11 GMT https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077773#M359452 NavinReddy 2016-03-03T06:06:11Z Re: How to get Distinct Year https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077774#M359453 <HTML><HEAD></HEAD><BODY><P>load *</P><P>Distinct([<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">MTRC_FCT_DT]) as&nbsp; newyear</SPAN></P></BODY></HTML> Thu, 03 Mar 2016 06:07:55 GMT https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077774#M359453 Chanty4u 2016-03-03T06:07:55Z Re: How to get Distinct Year https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077775#M359454 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>If you are getting year from Date field </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Year(YearStart(Date(Mid([MTRC_FCT_DT],1,8)))) as Year</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Regards,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">jagan.<BR /></SPAN></P></BODY></HTML> Thu, 03 Mar 2016 06:10:32 GMT https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077775#M359454 jagan 2016-03-03T06:10:32Z Re: How to get Distinct Year https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077776#M359455 <HTML><HEAD></HEAD><BODY><P>Try like this :</P><P>makedate(<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Mid([MTRC_FCT_DT],1,8)</SPAN>) as Year </P></BODY></HTML> Thu, 03 Mar 2016 06:17:16 GMT https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077776#M359455 avinashelite 2016-03-03T06:17:16Z Re: How to get Distinct Year https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077777#M359456 <HTML><HEAD></HEAD><BODY><P>Share your qvw, it would easy for us to help.</P></BODY></HTML> Thu, 03 Mar 2016 06:20:10 GMT https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077777#M359456 senpradip007 2016-03-03T06:20:10Z Re: How to get Distinct Year https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077778#M359457 <HTML><HEAD></HEAD><BODY><P>=Year(Yearstart(Year),1,4) as Year try this one</P></BODY></HTML> Thu, 03 Mar 2016 06:24:16 GMT https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077778#M359457 Anonymous 2016-03-03T06:24:16Z Re: How to get Distinct Year https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077779#M359458 <HTML><HEAD></HEAD><BODY><P>Use Year function to extract Year from Date.</P></BODY></HTML> Thu, 03 Mar 2016 06:28:14 GMT https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077779#M359458 Digvijay_Singh 2016-03-03T06:28:14Z Re: How to get Distinct Year https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077780#M359459 <HTML><HEAD></HEAD><BODY><P>May be,</P><P>need <STRONG>group by</STRONG></P><P></P><P>Share your .qvw to resolve it</P></BODY></HTML> Thu, 03 Mar 2016 07:04:54 GMT https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077780#M359459 tyagishaila 2016-03-03T07:04:54Z Re: How to get Distinct Year https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077781#M359460 <HTML><HEAD></HEAD><BODY><P><STRONG>What it is contain </STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>[MTRC_FCT_DT]??</STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Is this field contains Date only??<BR /></STRONG></SPAN></P></BODY></HTML> Thu, 03 Mar 2016 07:09:50 GMT https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077781#M359460 Anonymous 2016-03-03T07:09:50Z Re: How to get Distinct Year https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077782#M359461 <HTML><HEAD></HEAD><BODY><P>In list box to taken the distint values only</P></BODY></HTML> Thu, 03 Mar 2016 10:09:25 GMT https://community.qlik.com/t5/QlikView/How-to-get-Distinct-Year/m-p/1077782#M359461 Anonymous 2016-03-03T10:09:25Z