topic Re: Re: Number as text in QlikView

Number as text

Mon, 25 Nov 2013 13:18:22 GMT

Hi,

I have a few tables representing month as numbers 0, 1, 2 ... to 12. I no want to change the display of these numbers to text; Jan, Feb, March ... and so on. How do I do this?

Cheers,

Nils

Re: Number as text

sandeepprasad_j — Mon, 25 Nov 2013 13:21:26 GMT

Hello Nils,

Use Month() function

hope it helps

Sandeep.

Re: Number as text

christian77 — Mon, 25 Nov 2013 13:22:54 GMT

Hi.

In your script:

Month(MakeDate('2222',Month,'22')) as Month

First you create a date with your month.

After apply Month funktion.

Re: Number as text

MK_QSL — Mon, 25 Nov 2013 13:35:10 GMT

There are multiple ways

You can add an INLINE table in your script...

Load * INLINE

[

Month, MonthName

1, Jan

2, Feb

3, Mar

4, Apr

5, May

6, Jun

7, Jul

8, Aug

9, Sep

10, Oct

11, Nov

12, Dec

];

Or just use the below function to get MonthName from MonthNumber

=Month(MakeDate(Year(Today()),MonthNumber))

Re: Number as text

CELAMBARASAN — Mon, 25 Nov 2013 13:50:39 GMT

Use Month function.

It will give you Both Number and text on using like

Text(FieldName), Num(FieldName)

Ex:

Month(DateField) As FieldName

Re: Number as text

Clever_Anjos — Mon, 25 Nov 2013 13:58:22 GMT

You can use something like

LOAD
  SubField('$(MonthNames)',';',yournumfield) as yourmonthfield

Re: Number as text

Mon, 25 Nov 2013 14:02:03 GMT

thanks, this answer worked half-way . i am now getting the month names to appear, however i would like to also hide the numbers, so that only the month names are showing.

Re: Number as text

Mon, 25 Nov 2013 14:02:39 GMT

as with the answer below, this is also getting em half-way . am now getting the month names to appear, however i would like to also hide the numbers, so that only the month names are showing.

Re: Number as text

Thu, 28 Nov 2013 13:25:13 GMT

hi all,

i still havent gotten a full solution to this, anyone who can give it another try?

I have now gotten the month to appear together with the number of the month, however i need to number to be gone . any ideas?

Re: Number as text

Anonymous — Thu, 28 Nov 2013 13:43:35 GMT

Nils

Just use this :

Month ( Date# ( num( [YourMonthNumberField] , '00' ) , 'MM' ) )

Should ok in either your load script or your dashboard.

No need to do any Inline Loads.

Best Regards, Bill

Re: Number as text

Anonymous — Thu, 28 Nov 2013 13:47:45 GMT

A quick and dirty way to solve this is to multiply your month field with 30 and use the function Month where you want it to be displayed as text.

=Month([Month field]*30)

Re: Number as text

Thu, 28 Nov 2013 13:48:50 GMT

thanks bill, but that still doesnt make the numbers go away, which is really what i need. i need the text to replace the numbers, not add to them .

Re: Number as text

Thu, 28 Nov 2013 13:51:03 GMT

tnx, but this again doesnt solve the problem - i still have the numbers showing

Re: Number as text

Anonymous — Thu, 28 Nov 2013 13:56:34 GMT

Nils

It sure works for me, can you advise what kind of object you are using to show the month and the expression used..

Best Regards, Bill

Re: Number as text

Anonymous — Thu, 28 Nov 2013 13:59:22 GMT

Peter

That, as you say, certainly is dirty, but it does work even though I doubted it would.

I presume it works because date(1) is 31st Dec 1899.

Best Regards, Bill

Re: Number as text

Thu, 28 Nov 2013 14:01:15 GMT

i am using a list box to show the months. this is also where i try to add the expression

Re: Number as text

rustyfishbones — Thu, 28 Nov 2013 14:03:07 GMT

did you try

Re: Number as text

Anonymous — Thu, 28 Nov 2013 14:04:29 GMT

and could you share the expression ......................

Re: Number as text

Anonymous — Thu, 28 Nov 2013 14:06:37 GMT

and make sure on the Number tab you have not overridden the Default expression............

or set it to Date format of MMM.

Re: Number as text

saumyashah90 — Thu, 28 Nov 2013 14:07:45 GMT

In Script

You can do

Table1:

Load * Inline [

MonthNo

];

Table2:

Load Month(MakeDate(2013,MonthNo)) as Months resident Table1;

Drop table Table1;

OutPut:

Months

Jan

Feb

Mar

Apr

May

June

etc