topic Problem with date in QlikView

Problem with date

Thu, 21 Jan 2010 15:49:46 GMT

Hi, I have a question, i have my information with no date, the only thing i have are months and years, i need to change the numbers of the month in letters, does anyone can help me plz

Greetings and thanks

Problem with date

hector — Thu, 21 Jan 2010 16:00:36 GMT

can you try this?


month(makedate(Year_Field,Month_Field_numeric))

Explanation: makedate() creates a valid date with at least 1 parameter (year), with 2 or more, you can create any date you want, and month() will return the name of the month defined in the variable MonthNames

Rgds

Problem with date

Thu, 21 Jan 2010 16:22:06 GMT

I tried but didnt work, well it work but it doesnt make the relationship with the other data, look i have this formula:

sum({$<Year = {$(=only(Year))}, Month = {"<=$(=max(Month))"}>} LineSalesAmount)

Year = 2009

Month = 1

and i have a Month List Box 1,2,3,4,5,6,7,8,9,10,11,12 when i change it to Jan, Feb,....... the formula doesnt work

CAN YOU HELP ME PLS URGENT!!!!!!!!!!

Problem with date

hector — Thu, 21 Jan 2010 16:25:42 GMT

if the month field has a numeric value, but shows itself like 'Jan', you can use num(Month_Field), in case of Jan, it will return 1

rgds and good luck

Problem with date

hector — Thu, 21 Jan 2010 16:25:43 GMT

if the month field has a numeric value, but shows itself like 'Jan', you can use num(Month_Field), in case of Jan, it will return 1

rgds and good luck

Problem with date

Thu, 21 Jan 2010 16:50:47 GMT

]Thank you very much, be well

Problem with date

Thu, 21 Jan 2010 17:45:53 GMT

Does anybody has another solutions to my problem pls URGENT!!!

Problem with date

Thu, 21 Jan 2010 18:49:11 GMT

The "num(Month)" seems fine to me.

Using "Month" in a formula should be interpreted as an integer, even if it's displayed as a string in your list.

You can also create a separated table :


// Mapping months names.
Month_Name:
MAPPING LOAD * INLINE [
 x, y
 1, Janvier
 2, Février
 3, Mars
 4, Avril
 5, Mai
 6, Juin
 7, Juillet
 8, Août
 9, Septembre
 10, Octobre
 11, Novembre
 12, Décembre
];

add another field "LibMonth" in your table with those specific names :


 applymap('Month_Name', num(Month(TempDate)), null()) AS LibMonth

Instead of showing a list of "Month", display a list of "LibMonth". Your formula won't be affected.

Problem with date

Thu, 21 Jan 2010 19:04:23 GMT

Thanks nmartin, let me try and I send you my results

Regards,

Problem with date

Thu, 21 Jan 2010 19:39:58 GMT

How do you will apply your example in my formula, can you help with this pls???

sum({$<Year = {$(=only(Year))}, Month = {"<=$(=max(Month))"}>} LineSalesAmount)

thanks

Problem with date

Thu, 21 Jan 2010 20:42:32 GMT

ALGUIEN PODRIA YUDARME CON ESTO ES QUE NECESITO ENTREGAR MI APLICACION Y ES LO UNICO QUE ME FALTA, SOLICITO UN POCO DE AYUDA

Problem with date

hector — Fri, 22 Jan 2010 13:33:12 GMT

Hola, aun no se cual de todos es tu problema, si puedes sube una version del modelo con instrucciones de lo que quieras que se vea reflejado en el.

saludos

Problem with date

Fri, 22 Jan 2010 16:53:23 GMT

Mira mi problema es que en mi aplicacion manejo los datos con respecto al año y a los meses, en mi base de datos tengo mi campo Mes y lo manejo 1 para enero, 2 febrero y asi cosnecutivamente. Creo una tabla donde paso los valores de mi campo Mes y creo una columna que se llama MesLargo en el cual pongo los meses con letras.

Al momento de poner la formula:

SUM(Ventas_SUM)/(sum({$<Anio = {$(=only(Anio))}, Mes = {"<=$(=max(Mes))"}>} Ventas_SUM) )

en la parte de max(Mes) si me muestra el valor que es péro la formula no funciona como deberia.

Problem with date

hector — Fri, 22 Jan 2010 19:47:42 GMT

y como deberia funcionar?

Mejor dibuja una tabla y dinos el resultado esperado, segun veo en tu formula, es algo con los meses? como meses menores al actual?

saludos