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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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
tresB
Champion III
Champion III

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

tresB
Champion III
Champion III

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