Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Object-view after replace

Hey all!

It's a simple problem, I think, but I don't know what to do. After replace the separators in my Object "schlagwort", there are two columns. But I just want to see the right one with the nice "+" between the words. Cause... That's the reason why I replace the separators. Can you help me?

Thank you all!

2 Replies
swuehl
MVP
MVP

It looks like you are using a list box with an additional expression. This is similar to having a chart with dimension schlagwort and your expression, and you will see both columns.

You can use an expression instead of your field in the list box (choose <expression> from the field selection drop down in list box general properties), but it is better to create a new field in your load script that does the replace (or replace your original field with your modified):

LOAD

     replace(...) as schlagwort,

     ....

FROM ...;

If you want the list box solution:

=aggr( replace(...), schlagwort)

[You'll need to use your complete replace expression of course].

Hope this helps,

Stefan

Not applicable
Author

Thank you Stefan,

it works. I wrote the replace-statement in the load script. It's so simple!

😄

Inga