topic Re: return the value text name in QlikView

return the value text name

Anonymous — Thu, 13 Aug 2015 18:44:35 GMT

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

Re: return the value text name

Thu, 13 Aug 2015 18:46:14 GMT

You mean 'Ten' for the number 10?

Re: return the value text name

Kushal_Chawda — Thu, 13 Aug 2015 18:52:30 GMT

Please elaborate more on the requirement

Re: return the value text name

Anonymous — Thu, 13 Aug 2015 18:54:49 GMT

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

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

Re: return the value text name

Anonymous — Thu, 13 Aug 2015 18:58:36 GMT

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.

Re: return the value text name

sasiparupudi1 — Thu, 13 Aug 2015 19:02:57 GMT

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

Re: return the value text name

antoniotiman — Thu, 13 Aug 2015 19:03:47 GMT

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

Re: return the value text name

Anonymous — Thu, 13 Aug 2015 19:08:34 GMT

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?

Re: return the value text name

Kushal_Chawda — Thu, 13 Aug 2015 19:10:43 GMT

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 ];

Re: return the value text name

Qrishna — Thu, 13 Aug 2015 19:12:21 GMT

See attached.

Re: return the value text name

maxgro — Thu, 13 Aug 2015 19:22:25 GMT

maybe

text(Media)

num(Media)

Re: return the value text name

sasiparupudi1 — Thu, 13 Aug 2015 19:42:01 GMT

could you post some sample data for the media field?

Re: return the value text name

Thu, 13 Aug 2015 19:48:50 GMT

If your field is Dual you can forcefully convert to either format with Text & Num function.

Try like below:

Text(Only(MonthField))

Re: return the value text name

MarcoWedel — Thu, 13 Aug 2015 21:10:21 GMT

‌Date(Date#(10,'M'),'MMMM')

regards

Marco

Re: return the value text name

qlikviewwizard — Fri, 14 Aug 2015 03:03:34 GMT

Hi larisa_filonova

Please close the thread by selecting Correct Answer and Helpful. Thank you.

Re: return the value text name

Anonymous — Fri, 14 Aug 2015 08:27:02 GMT

That's a useful example. Thank you!

Re: return the value text name

Anonymous — Fri, 14 Aug 2015 08:28:24 GMT

Thanks everyone for your comments!