Help Debutant QlikView

[#1]

Hello,

I start on QlikView and would need some information please.

I have to do a file that contains encrypted months (1-2-3-4 ... 12)

I'd like to turn those months encrypted months:

1 -> January

2 -> February

...

12 -> December

Can anyone please give me the pipe?

I thank you in advance.

Best regards

[datanibbler]

Hi,

then you'll have to use a MAPPING LOAD and the Applymap() function or you can use the Makedate() function to turn that month_nr. into the first of that month and then use the Month() function on that.

HTH

[Anonymous]

    =date(date#('1','M'),'MMMM')

And for the 1 substitute your month field.

[Peter_Cammaert]

If your encryption consists of giving them a numeric value, use date#() or MakeDate() to convert them into a Date value internally. From there on, you can format them any way you like.

In QlikView, date values are stored internally as dual values: QlikView keeps a numeric value (days since epoch) and a string representation that you can change with the Date() function. This technique gives you the power of doing calculations with date values while retaining the particular presentation string (Long Month Name) you prefer.

Peter

[#5]

Hi,

Thank you very much for you answer.

Julien

[Anonymous]

Julien

If you found any of the responses Helpful or Correct it is good etiquette on this to mark them as such.