Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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?

1 Solution

Accepted Solutions
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

View solution in original post

15 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     What is the relation between numeric values for clients,pharmacies and names of the clients ,pharmacies?

     little more briefer please.

Celambarasan

Anonymous
Not applicable
Author

I'm not exactly sure.

LOAD agentcode,

     agentname,

     callduration,

     callid,

     id,

     profileno as Client,

     ramsno as 'Pharmacy Name',

     statedescription,

     timestamp

FROM

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

(qvd);

This is all the data in the script I have

Does that help anymore, or is there further info I can provide to make it easier to help out?

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Which table has Clientname and Pahrmacy name for its corresponding profileno and ramsno ?

Celambarasan

Anonymous
Not applicable
Author

Sorry, I don't know.  Do these tables possibly exist outside of my qlikview model?

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

      Check the database what all the tables related to the fields profileno and ramsno.

      You need them to get the client name and pharmacy name.

      if you don't the info then ask your client to provide that information.

Celambarasan

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try this script and check whether any extra columns are fetched, if extra columns are fetched then look for the Client and Pharmacy name columns.

LOAD

     *

FROM

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

(qvd);

Hope this helps you.

Regards,

Jagan.

Anonymous
Not applicable
Author

Ok, I see the table that lists ramsno with the corresponding pharmacy name

Here is the syntax of the script that appears when I select it

SELECT TOP 1000 [Ramsno]

      ,[PharmacyName]

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

Do I need to put this directly into the script, or do I need to load this table into the script?

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     If you already made a connection to the database in script means then you can use this script directly.

Celambarasan

Anonymous
Not applicable
Author

do I use the exact script besides:

Select Top 1000      ??

I'm not sure where in the script to put it either