change numeric values to text

[Anonymous]

The tables I loaded into qlikview show numeric values for clients and pharmacies.

How do I change the numeric values into the names of the clients and pharmacies?

[jagan]

Hi,

Add connection string to database and use the following script below

TableName:

SQL SELECT TOP 1000

     [ramsno],

     [PharmacyName]

  FROM [CCP_Compliance].[dbo].[ref_Pharmacies];

Modify your previous script to this

LOAD agentcode,

     agentname,

     callduration,

     callid,

     id,

     profileno as Client,

     ramsno ,

     statedescription,

     timestamp

FROM

C:\Users\chrisg\Documents\CallLogs.qvd

(qvd);

So that both tables has a relation, ramsno(FieldName) should be common in both the tables.

Regards,

Jagan.

[jagan]

Hi,

Select TOP 1000

fetches first 1000 rows.  If you just need 1000 rows keep as such, else remove Top 1000.

Regards,

Jagan.

[CELAMBARASAN · Accepted solution]

Hi,

     Use like this.

Pharmacy:

SQL SELECT

     [ramsno],

     [PharmacyName]

  FROM [CCP_Compliance].[dbo].[ref_Pharmacies];

CallLog:

LOAD agentcode,

     agentname,

     callduration,

     callid,

     id,

     profileno,

     ramsno,

     statedescription,

     timestamp

FROM

C:\Users\chrisg\Documents\CallLogs.qvd

(qvd);

Qlikview has feature that it automatically joins the field which has common name.Here you don't need to join the two tables.

Celambarasan

[Anonymous]

Works great, thanks a lot for your help!

[Anonymous]

I'm having trouble with the Client names and data. Here is the script I used, but when I reload it says there is an error

Client: 

SQL SELECT

      [ProfileNo],

      [PatientName],

      [PatientTelNo],

      [ContactName],

      [ContactTelNo],

      [ContactCellNo],

      [ContactAddress1],

      [ContactAddress2],

      [ContactAddress3],

      [CallIncrementFlag],

      [InitialCallDate],

      [RamsNo],

      [Notes],

  FROM [CCP_Compliance].[dbo].[ex_ProfileMaster];

**************the entire script reads

Pharmacy:

SQL SELECT

     [ramsno],

     [PharmacyName]

  FROM [CCP_Compliance].[dbo].[ref_Pharmacies];

Client: 

SQL SELECT

      [ProfileNo],

      [PatientName],

      [PatientTelNo],

      [ContactName],

      [ContactTelNo],

      [ContactCellNo],

      [ContactAddress1],

      [ContactAddress2],

      [ContactAddress3],

      [CallIncrementFlag],

      [InitialCallDate],

      [RamsNo],

      [Notes],

  FROM [CCP_Compliance].[dbo].[ex_ProfileMaster];

LOAD agentcode,

     agentname,

     callduration,

     callid,

     id,

     profileno as Client,

     ramsno as 'Pharmacy Name',

     statedescription,

     timestamp

FROM

C:\Users\chrisg\Documents\CallLogs.qvd

(qvd);

[CELAMBARASAN]

Hi,

     It shows what error can you upload the screenshot?

     Did you made a connection to database in script?

Celambarasan