topic Re: Problema sulle date in QlikView https://community.qlik.com/t5/QlikView/Problema-sulle-date/m-p/644351#M543281 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>try <SPAN style="font-size: 10pt; line-height: 1.5em;">below</SPAN></P><P></P><P>Load</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Data_documento, </SPAN></P><P>.</P><P>.</P><P>.</P><P>year(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Data_documento</SPAN>) as Year,</P><P style="direction: rtl;">Month(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Data_documento</SPAN>) as Month</P><P style="direction: rtl;">;from xyz</P><P style="direction: rtl;"></P><P style="direction: rtl;">Regards</P><P style="direction: rtl;"><SPAN style="font-size: 10pt; line-height: 1.5em;">ASHFAQ</SPAN></P></BODY></HTML> Mon, 09 Jun 2014 10:57:49 GMT ashfaq_haseeb 2014-06-09T10:57:49Z Problema sulle date https://community.qlik.com/t5/QlikView/Problema-sulle-date/m-p/644349#M543279 <HTML><HEAD></HEAD><BODY><P>Ciao a tutti.</P><P>Ho creato un foglio con un campo Data_documento con formato GG.MM.YYYY</P><P>Da questo campo voglio ottenere l'anno e il mese per poterli poi utilizzare come ulteriori campi e richiamarli in altri oggetti, ad esempio in grafici.</P><P>Come posso fare?</P><P>Grazie mille</P><P>Pasq</P></BODY></HTML> Mon, 09 Jun 2014 10:51:30 GMT https://community.qlik.com/t5/QlikView/Problema-sulle-date/m-p/644349#M543279 2014-06-09T10:51:30Z Re: Problema sulle date https://community.qlik.com/t5/QlikView/Problema-sulle-date/m-p/644350#M543280 <HTML><HEAD></HEAD><BODY><P>Provare come:</P><P></P><P>Load</P><P>Year(Date#(Data_documento,'GG.MM.YYYY')) As Year,</P><P>Month(Date#(Data_documento,'GG.MM.YYYY'))&nbsp; AS Month</P></BODY></HTML> Mon, 09 Jun 2014 10:57:34 GMT https://community.qlik.com/t5/QlikView/Problema-sulle-date/m-p/644350#M543280 senpradip007 2014-06-09T10:57:34Z Re: Problema sulle date https://community.qlik.com/t5/QlikView/Problema-sulle-date/m-p/644351#M543281 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>try <SPAN style="font-size: 10pt; line-height: 1.5em;">below</SPAN></P><P></P><P>Load</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Data_documento, </SPAN></P><P>.</P><P>.</P><P>.</P><P>year(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Data_documento</SPAN>) as Year,</P><P style="direction: rtl;">Month(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Data_documento</SPAN>) as Month</P><P style="direction: rtl;">;from xyz</P><P style="direction: rtl;"></P><P style="direction: rtl;">Regards</P><P style="direction: rtl;"><SPAN style="font-size: 10pt; line-height: 1.5em;">ASHFAQ</SPAN></P></BODY></HTML> Mon, 09 Jun 2014 10:57:49 GMT https://community.qlik.com/t5/QlikView/Problema-sulle-date/m-p/644351#M543281 ashfaq_haseeb 2014-06-09T10:57:49Z