How can i concatenate / merge or show 2 string fields in 1 list box

[#1]

How can i concatenate 2 string fields in 1 list box (same Source and Target Type ) ?

How can I relate selected values ?

I attached a excel file clearly discrebed what i want to make. (test.xlsx)

I hope it is possible. I am looking forward your help as a qvw solition

Thanks

[Sokkorn]

Hi,

I'm not sure this one you looking for:

[Data]:
LOAD ModelName, 
     SourceType, 
     SourceName, 
     ConnectionName, 
     TargetType, 
     TargetName,
     IF([SourceType]='Act' OR [TargetType]='Act',[SourceName] &' - '& TargetName)    AS [Activities],
     IF([SourceType]='Doc' OR [TargetType]='Doc',[SourceName] &' - '& TargetName)    AS [Documents],
     IF([SourceType]='Org' OR [TargetType]='Org',[SourceName] &' - '& TargetName)    AS [Org]
FROM [Copy of TEST.xlsx] (ooxml, embedded labels, table is Sayfa1);

See attached file also.

Regards,

Sokkorn Cheav

[#3]

First of all Thank you for your interest.

Actually I want to see records as row by row not one row in two record. (A-B, ....)

I need like this

Activities ( A, B, D, K) -> each record should be one row.

when i click activity in Activities Listbox, related documents or org should be shown

Thanks

[sridhar240784]

Hi,

If i understood your requirement correctly, you may look at Concat() function in help. This helps to achieve your requiremnent

-Sridhar

[SunilChauhan]

use fomulae like below

if (SourceType='Act' or TargetType ='Act',SourceName&'-'& TargetName)

if (SourceType='Doc' or TargetType ='Doc',SourceName&'-'& TargetName)

if (SourceType='Org' or TargetType ='Org',SourceName&'-'& TargetName)

hope this help

[Sokkorn]

Hi,

Can you give me the result that you looking for? I think function CONCAT() maybe do your job.

Regards,

Sokkorn Cheav

[#7]

I tried to explain what i am looking for in attachment document.

Thank you

[#8]

hi... i hope this works for you, i didnt understood very well the result that you are expecting... but if im close enough we can work on it..

Step 1... script

source_table:
LOAD ModelName,
     SourceType,
     SourceType as link_field,
     if(SourceType = 'Act',SourceName) as activities,
     if(SourceType = 'Org',SourceName) as org,
     if(SourceType = 'Doc',SourceName) as documents,

     SourceName,
     ConnectionName,
     TargetType as TargetType_source,
     TargetName as TargetName_source,
     if(TargetType = 'Act',TargetName) as target_activities,
     if(TargetType = 'Org',TargetName) as target_org,
     if(TargetType = 'Doc',TargetName) as target_documents,
     G,
     H
FROM
Z:\Desktop\TEST2.xlsx
(ooxml, embedded labels, table is DATA);

Step 2... remember to change de file (Z:\Desktop\TEST2.xlsx works for me)

Step 3...

in the dashboard create new object list with the folowing field

left side

- SourceType

- activities

- documents

- org

right side

- TargetType_source

- target_activities

- target_documents

- target_org

i dont know how to attach a file here but if you want i can mail you my test qlikview file

saludos desde venezuela...

Feliz Año Nuevo (happy new year)