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: 
vvvvvvvvvv
Creator
Creator

Store value in field into variable

If I have a table 
Temp:

Load * inline[

A      B
A1   B1
A1  B2
A2  B2
A2  B1

]

Can I store all value of B into another variable if corresponding A  = A1 without using data editor? Using create variable in Analysis?


Since I want to just use the variable to create default bookmark

Labels (1)
4 Replies
tresesco
MVP
MVP

Try your variable definition as:

Concat(Distinct {<A={'A1'}>}, B , ',')

vvvvvvvvvv
Creator
Creator
Author

I don't want concat since I want to show in separated item in the table

tresesco
MVP
MVP

Do you mean, if there are multiple possible values in B field - you would want them in multiple variables...?

raji6763
Creator II
Creator II

you can achieve this in script editor