Text appending 0 while coercing to string

[kaustubh]

Dear All,

I have to join two tables based on string field. 'referral' and 'refprov'.

The referral has column 'refer_from' and refprov has 'rfocode'. When I use text(), the string '20' and '020' both turns to '020'.

But in reality they are separate physician code.

Data of refprov:

rfocode   rfoname

20               Robert W

020             Sultan A

Data for referral:

refer_from       referralnum

20                          2842

result expected:

Table 1  View                                                                           Table 2 view

referring Phy.           Code                                                            ref.no.

Robert W                       20                                                               2842

This must be displayed in QlikSense sheet on table.

Can someone please guide me on what might be causing this? Is there any work around or am I missing anything?

Thanks.

[kaustubh]

Dear All,

I went through few articles and tried using Text function as per one of the suggestions here during QVD creation. I recreated everything from scratch and now it is working. Thank you here to everyone for your help. It was frustrating. 

Take Care.