Expression Review

[#1]

CUST_ADDR2 & ' ' & CUST_CITY & '' &CUST_STATE & '' &CUST_ZIP & '' &CUST_COUNTRY as [Supplier Location]

After Concatenate my data for supplier location is like this .Please find Screen shot

My requirement is i need to see data in this format..PFA screen shot

[Sokkorn]

Hi Reddy,

Can you upload your sample data and manipulate your desire result? So that it easy for other to test with QlikView.

Regards,

Sokkorn

[sujeetsingh]

just use a straight table and seet the settings in custom setting