Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

return the value text name

Hi,

I've got a dual Field Month.

I need to set an expression which returns a text value which corresponds to a particular numeric value.

Say, I've got number X.

I'd like to set a function which returns the text value of X.

Is it possible?

Thank you in advance,

Larisa

1 Solution

Accepted Solutions
Highlighted
Specialist III
Specialist III

Re: return the value text name

16 Replies
Highlighted
Not applicable

Re: return the value text name

You mean 'Ten' for the number 10?

Highlighted

Re: return the value text name

Please elaborate more on the requirement

Highlighted
Creator III
Creator III

Re: return the value text name

No, I mean 'October' for the number 10.

The field Month is dual. So, every month has got its number.

Highlighted
Creator III
Creator III

Re: return the value text name

Each value of the Field month in dual.

So if I set number 1 the expression shoul return 'January',

if I set number 2 the expression shoul return 'February' and so on.

Highlighted
Master III
Master III

Re: return the value text name

=date(makedate(year(today()),10),'MMMMM')

Highlighted
Master III
Master III

Re: return the value text name

You have dual field if in Your Script You have

Month(Date) as Month

if Date is a valid date field.

Month is Dual field

Highlighted
Creator III
Creator III

Re: return the value text name

Actually, I've got several dual fields.

one is Month, another is Media (each media has got its own text and numeric value).

Is it possible to solve the task for the Media field as well?

Highlighted

Re: return the value text name

Create the Month using Date field

Date(YourDateField,'MMMM') as Month

Create the inline table to assign number

load * inline [

MonthNum, Month

1, January

2, February

3,March

4,April,

5,May

6,June

7,July

8,August

9,September

10,October

11,November

12,December ];

Highlighted
Specialist III
Specialist III

Re: return the value text name