Concatenation not working

[kamalqlik]

Hi friends,  

             I am stuck in a problem and I need your help.

Below is the code attached

When I am selecting the SBU in the List box and I select the SalesType on the other list box than I am not able to see the value for the target which is coming from the above script than it does not show the value.

But when i remove the Concatenation I get the value.

But I have to use the concatenation as I have to get the value in my fact table.

I think I have to apply force concatenation by Sales Type field.

But I don't know how to dat.....

Thanks and regards

Kamal

[#2]

Hi,

Can you add the .qvw file and let us know which tables don't seem to be concatenating properly?  Might be easier to see it in context.

Thanks,

Emma