I have 2 QVDs which contain the same field (Subledger). The values in this field consist of 8 total characters. In most cases it is a 4-digit number followed by 4 empty spaces. For some reason, when QlikView loads this field from my first QVD, it left-justifies the values. But when QV pulls in the same value from my second QVD, it right-justifies the value.
Notice that each value is 8 characters long and the '0001' is in the first 4 positions followed by 4 empty spaces. In the first QVD, the values are generated and intentionally made as text ( text('00'&Trim(UserDefinedCode)&' ') as Subledger). The second QVD is a system generated QVD.
Does anyone know what I can do to make QV treat values from both tables the same? Hope this question makes sense . . .