topic ayuda con qpliview in QlikView https://community.qlik.com/t5/QlikView/ayuda-con-qpliview/m-p/613297#M1102823 <HTML><HEAD></HEAD><BODY><P>hola&nbsp; soy nuevo en qlikview&nbsp; y necesito&nbsp; obtener los&nbsp; ultimos&nbsp; 12 meses&nbsp;&nbsp; de acuerdo en el mes que me encuentre</P><P>que&nbsp; vaya cambiando a&nbsp; medida que ingrese otro mes , Año</P><P></P><P>LOAD id,</P><P>&nbsp;&nbsp;&nbsp; "Player ID",</P><P>&nbsp;&nbsp;&nbsp; day(Fecha) as Dia_Fecha,</P><P>&nbsp;&nbsp;&nbsp; DayName(Fecha) as Dia_fecha_Nombre,</P><P>&nbsp;&nbsp;&nbsp; Month(Num(Fecha)) as Mes_Fecha,</P><P>&nbsp;&nbsp;&nbsp; "Apellido y Nombre",</P><P>&nbsp;&nbsp;&nbsp; Month(Num(Fecha))as Fecha_mes,</P><P>&nbsp;&nbsp;&nbsp; "Time Played (mm)",</P><P>&nbsp;&nbsp;&nbsp; "Number of Points",</P><P>&nbsp;&nbsp;&nbsp; "Total&nbsp; In $",</P><P>&nbsp;&nbsp;&nbsp; "Total Out $",</P><P>&nbsp;&nbsp;&nbsp; "Bill In $",</P><P>&nbsp;&nbsp;&nbsp; "Jackpot $",</P><P>&nbsp;&nbsp;&nbsp; Age,</P><P>&nbsp;&nbsp;&nbsp; "City / Town",</P><P>&nbsp;&nbsp;&nbsp; "PLAYER LEVEL",</P><P>&nbsp;&nbsp;&nbsp; Gender,</P><P>&nbsp;&nbsp;&nbsp; "Postal code",</P><P>&nbsp;&nbsp;&nbsp; "Hour Start",</P><P>&nbsp;&nbsp;&nbsp; "Tarjeta CHIPCASH",</P><P>&nbsp;&nbsp;&nbsp; DIA,</P><P>&nbsp;&nbsp;&nbsp; "Año",</P><P>&nbsp;&nbsp;&nbsp; Fecha;</P><P>SQL SELECT *</P><P>FROM base.dbo."Tabla_postal";</P></BODY></HTML> Tue, 08 Apr 2014 12:20:26 GMT jose123456 2014-04-08T12:20:26Z ayuda con qpliview https://community.qlik.com/t5/QlikView/ayuda-con-qpliview/m-p/613297#M1102823 <HTML><HEAD></HEAD><BODY><P>hola&nbsp; soy nuevo en qlikview&nbsp; y necesito&nbsp; obtener los&nbsp; ultimos&nbsp; 12 meses&nbsp;&nbsp; de acuerdo en el mes que me encuentre</P><P>que&nbsp; vaya cambiando a&nbsp; medida que ingrese otro mes , Año</P><P></P><P>LOAD id,</P><P>&nbsp;&nbsp;&nbsp; "Player ID",</P><P>&nbsp;&nbsp;&nbsp; day(Fecha) as Dia_Fecha,</P><P>&nbsp;&nbsp;&nbsp; DayName(Fecha) as Dia_fecha_Nombre,</P><P>&nbsp;&nbsp;&nbsp; Month(Num(Fecha)) as Mes_Fecha,</P><P>&nbsp;&nbsp;&nbsp; "Apellido y Nombre",</P><P>&nbsp;&nbsp;&nbsp; Month(Num(Fecha))as Fecha_mes,</P><P>&nbsp;&nbsp;&nbsp; "Time Played (mm)",</P><P>&nbsp;&nbsp;&nbsp; "Number of Points",</P><P>&nbsp;&nbsp;&nbsp; "Total&nbsp; In $",</P><P>&nbsp;&nbsp;&nbsp; "Total Out $",</P><P>&nbsp;&nbsp;&nbsp; "Bill In $",</P><P>&nbsp;&nbsp;&nbsp; "Jackpot $",</P><P>&nbsp;&nbsp;&nbsp; Age,</P><P>&nbsp;&nbsp;&nbsp; "City / Town",</P><P>&nbsp;&nbsp;&nbsp; "PLAYER LEVEL",</P><P>&nbsp;&nbsp;&nbsp; Gender,</P><P>&nbsp;&nbsp;&nbsp; "Postal code",</P><P>&nbsp;&nbsp;&nbsp; "Hour Start",</P><P>&nbsp;&nbsp;&nbsp; "Tarjeta CHIPCASH",</P><P>&nbsp;&nbsp;&nbsp; DIA,</P><P>&nbsp;&nbsp;&nbsp; "Año",</P><P>&nbsp;&nbsp;&nbsp; Fecha;</P><P>SQL SELECT *</P><P>FROM base.dbo."Tabla_postal";</P></BODY></HTML> Tue, 08 Apr 2014 12:20:26 GMT https://community.qlik.com/t5/QlikView/ayuda-con-qpliview/m-p/613297#M1102823 jose123456 2014-04-08T12:20:26Z