Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

linking tables imported from shareroom

Hey all,

I am facing following issue. I load a list of items from a MS ShareRoom into my QlikView:

Column1Column2Column3
QMQualitätsmanagementquality management
PMProjektmanagementproject management
.........

Everything works with following load-script:

system_parameters:

LOAD [Column1] as parameters,

           [Column2] as parameters_de,

           [Column3] as parameters_en

FROM

[shareroom link]

(html, utf8, embedded labels, table is ...);

Now I have an additional list with several colums which one of contains parameters from the parameter list. I load them quite similar. Because I can choose multiple Items as parameter, ShareRoom lists the items like this "QM, PM, ..." so I use PurgeChar() to purge the blanks:

Column1Column2Column3
1title blaQM, PM
2title blubPM
3title blaeh...

Everything works again with following load-script:

shareroom:

LOAD [Column1] as id,

           [Column2] as title,

           PurgeChar([Column3],' ') as system

FROM

[shareroom link]

(html, utf8, embedded labels, table is ...);

Now I need to connect those tables, so I created a link_table:

link_table:

LOAD system,

           Subfield(system,',') as parameters

Resident shareroom;

While I used the same method with my tables in Excel everything worked. But with the ShareRoom lists it doesn't work. I see the parameters doubled and they don't link while clicking them. Anyone has an idea what could be wrong? Thanks a lot!

0 Replies