Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
thewillemzelluf
Contributor III
Contributor III

same number as seperate dimensions

Hello, I have concatenated different customer tables for an overview. This is because there are 2 tables in which customer '125' appears. However, it seems that the format of this is different because if I want to merge all the results, qliksense keeps seeing the same number as 2 separate dimensions. Could this be because a different format applies (num or text)?

Thanks in advance!

 

Labels (1)
1 Solution

Accepted Solutions
dilipranjith
Partner
Partner

How are you merging the tables? concatenate?
from a high level type issue looks most likely reason. try num#(trim(yourfield))

i would try that and maybe diagnose it by loading the tables separatly and checking the data type on the model

View solution in original post

2 Replies
dilipranjith
Partner
Partner

How are you merging the tables? concatenate?
from a high level type issue looks most likely reason. try num#(trim(yourfield))

i would try that and maybe diagnose it by loading the tables separatly and checking the data type on the model

View solution in original post

thewillemzelluf
Contributor III
Contributor III
Author

Thankyou! trim was enough! 🙂