Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

change numeric values to text

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?

15 Replies
jagan
Luminary Alumni
Luminary Alumni

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
Luminary Alumni
Luminary Alumni

Hi,

Select TOP 1000

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

Regards,

Jagan.

CELAMBARASAN
Partner - Champion
Partner - Champion

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
Not applicable
Author

Works great, thanks a lot for your help!

Anonymous
Not applicable
Author

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
Partner - Champion
Partner - Champion

Hi,

     It shows what error can you upload the screenshot?

     Did you made a connection to database in script?

Celambarasan