Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Specialist
Specialist

Missing 'DOT' / Period character in item list

I am building a dash board from multiple QVD's

I have an issue where an item name is losing a suffixed "." Dot.

In the image attached you can see in one load CHZ, the items does not have this character on the item but in CYY the same item does have the DOT

When i concatenate the data i am finding no records are missing but for the CYY the . is missing from the item name.

Does anyone know of any strange handling of data when it comes to this "." in a name for use in QV?

Missing Period character.png

 

I have checked the source data and there is no time when the Invoice number does not have the . in the item

I do have values in the Dashboard with items having a . but there is no value without the . from any source.

Any help/explanation would be much appreciated.

Thanks

Daniel

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

Try loading the Item No field as text:

text([Item No.] as [Item No.]

View solution in original post

3 Replies
m_woolf
Master II
Master II

Try loading the Item No field as text:

text([Item No.] as [Item No.]

davyqliks
Specialist
Specialist
Author

Thanks for the reply,

I will give this a go and let you know how it goes.

Regards,

Daniel

davyqliks
Specialist
Specialist
Author

Thank you so much for taking the time to assist. this worked perfectly to get me both values in the merged data load.

Regards,

Daniel