Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
prajapatiamar38
Creator II
Creator II

Number to Text?

Hi Community,

I have a scenario I have a field called Numbers in that values are 1,2,3,4........ up to 1000.Now i want when i click any number it will display the text of that number in text object.

For Example: If i select 50 it should display "Fifty",

                     if i select 552 it will display "Five Hundred Fifty two" ..........like that for all numbers.

How can i do this........

Plz suggest

Thanks and Regards

Amarnath

14 Replies
prajapatiamar38
Creator II
Creator II
Author

Hi

I want without writing the text for each number.

gautik92
Specialist III
Specialist III

i have attached excel for that did you check that?

sasiparupudi1
Master III
Master III

I would generate the maximum possible numbers and their corresponding words in the excel(2 columns)

load in to qv as a mapping load

use applymap on the number column in your target table to get the words

hth

Sasi

prajapatiamar38
Creator II
Creator II
Author

Can you share one sample application.

gautik92
Specialist III
Specialist III

Have a look at this