Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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