Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ahmed_hassan
Contributor III
Contributor III

QlikView doesn't convert all text values to numbers

 
 

Dear Community,

I used the below mapping to merge several values e.g.  9 (as text) &  9B &  9A  into 9 (as number). However, for some reason QlikView does not convert e.g.  9 (as text) to 9 (as number) as shown in the screenshot. Any idea what I can do? Thanks

 

 

Mapping Load * Inline[

From, To
9 , 9
9B, 9 
9A, 9
8 , 8 
8+, 8 
8-, 8
7 , 7 
7+, 7 
7-, 7
6 , 6 
6+, 6 
6-, 6
5 , 5 
5+, 5 
5-, 5
4 , 4 
4+, 4 
4-, 4
3 , 3 
3+, 3 
3-, 3 
2+, 2 
2-, 2 
2 , 2
];

 

 

Rating.png

1 Solution

Accepted Solutions
ahmed_hassan
Contributor III
Contributor III
Author

NUM#(Filed) solved the issue.

View solution in original post

1 Reply
ahmed_hassan
Contributor III
Contributor III
Author

NUM#(Filed) solved the issue.