return the value text name

[Anonymous]

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

[maxgro]

maybe

text(Media)

num(Media)

[sasiparupudi1]

could you post some sample data for the media field?

[#4]

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

Try like below:

Text(Only(MonthField))

[MarcoWedel]

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

regards

Marco

[qlikviewwizard]

Hi larisa_filonova

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

[Anonymous]

That's a useful example. Thank you!

[Anonymous]

Thanks everyone for your comments!