General Q.

[Mahamed_Qlik]

Dear all,

I have data in numeric and i wan to display it in alphbets as follows:

Number
1
2
3
4
5
6
7
8
9
10

I need :

if i click on number 1 then a text box should display as one similar if i click on 2 then it should show TWO...similar if i have list of number till 120000 and if I select a number 11221 then it should display as   "Eleven Thousand two hundred twenty one"

Kindly suggest,

Mahamed.

[miguelbraga]

Hi there,

This could be done with ApplyMap with a convertion table in a excel file with two field [Number] and [Number Text]. Otherwise, anyone correct if I'm wrong, I can't see another way you can do what you want. If there is some other way, others will tell you

Regards,

MB

[marcus_sommer]

Have a look here: how to convert number into words

- Marcus

[Anonymous]

Two option:

1)  Go for Excel Sheet and define one by one and create one more column for String Values

2) Create a inline function in QV like:

Load * inline

[ID, Values

1, One

2,Two

3,Three

and so on......

];

[Mahamed_Qlik]

Hey Balraj,

Thanks for your comment but I don't want to do it excel till the number i want.

[Mahamed_Qlik]

Not helpful..

Thanks for the comment

[Anonymous]

May be sth like already suggested by Marcus

[Mahamed_Qlik]

Yes Balraj...But I am not able to do it in Qlik.

[marcus_sommer]

Why not - it's the only way to create it. But you could search here https://www.google.de/search?q=numbers+in+word if somebody have it already done and you could download such (mapping) table.

- Marcus

[Anonymous]

What issue you are facing?

See, If you want to define Numersics along with String values, then these are the workarounds in Qlik...

Apart from these I dont think any other way is possible