Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Qlik Sense: Unable to replace numeric values in qvds

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
NaoBaba
Support
Support

Qlik Sense: Unable to replace numeric values in qvds

Last Update:

Feb 8, 2024 4:11:09 AM

Updated By:

Sonja_Bauernfeind

Created date:

Feb 8, 2024 11:05:03 PM

Qlik Sense includes a feature allowing you to replace field values in a table. This feature works as expected with, for example, Excel files, but numeric values in qvds cannot be replaced.

Resolution

This behaviour with qvd files is expected. The mapping table mismatches text values with their numerical values.

Workaround

Option One

Use the same data with an Excel or text file instead.

 

Option Two

Convert the mapping table to text values.

Example:

temp:
LOAD * INLINE
[
from,to
3,8
1,8
'',8
0,8
2,8
];[F1Mapping]:
MAPPING Load
text(from) as [F1Mapping-FROM],
text(to) as [F1Mapping-TO]
resident temp; 

 

Related Content 

Replacing field values in a table 

 

Internal Investigation ID(s) 

QB-24461

 

Environment

  • Qlik Cloud
  • Qlik Sense Enterprise all versions
  • Qlik Sense Desktop all versions
Labels (1)
Version history
Last update:
3 weeks ago
Updated by: