Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ZuzJesk
Contributor
Contributor

concat + set expression

Hi there, let's imagine I have a following sample table in the load script:

DocumentWordContext
AAAHi1
AAAthere2
BBHow1
BBare2
BByou3
CHi1
CI2
Cam3
Cfine4

 

In some field in the frontend, I'd like to concat the Words to a sentense, e.g. using simple Concat( Word, ' ', WordPosition) BUT if I filter some Word in a filter, it displays only the Word, not the whole sentense. Thus I need to change the contact expression to get all the words for the asociated Document, something like

Concat( {< Word=p(AllPossibleWordsForDocumentAssociatedWithTheWordSelection)>}Word, ' ', [WordPosition])

I'd really appreciate some help 🙂

Labels (2)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Concat({<Word=, Document=P(Document)>}Word,' ', Context) 

-Rob

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Concat({<Word=, Document=P(Document)>}Word,' ', Context) 

-Rob

ZuzJesk
Contributor
Contributor
Author

absolutely brilliant! and so easy! thanks a lot! 🙂