Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Hi,
Select TOP 1000
fetches first 1000 rows. If you just need 1000 rows keep as such, else remove Top 1000.
Regards,
Jagan.
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
Works great, thanks a lot for your help!
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);
Hi,
It shows what error can you upload the screenshot?
Did you made a connection to database in script?
Celambarasan