topic Re: Help Debutant QlikView in QlikView

Help Debutant QlikView

Tue, 23 Jun 2015 07:16:20 GMT

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

Re: Help Debutant QlikView

datanibbler — Tue, 23 Jun 2015 08:17:57 GMT

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

Re: Help Debutant QlikView

Anonymous — Tue, 23 Jun 2015 08:21:27 GMT

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

And for the 1 substitute your month field.

Re: Help Debutant QlikView

Peter_Cammaert — Tue, 23 Jun 2015 08:27:25 GMT

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

Re: Help Debutant QlikView

Tue, 23 Jun 2015 09:06:45 GMT

Hi,

Thank you very much for you answer.

Julien

Re: Help Debutant QlikView

Anonymous — Tue, 23 Jun 2015 09:21:49 GMT

Julien

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