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: 
chriys1337
Creator III
Creator III

Copy (multiple) possible values into another field

Hi,

would like to copy 10 ID's from field A with right click, "copy possible values" into another field B.

Is there any trick how to do it? When I paste the values into a text document, all IDs are one below the other.

But when I try to paste it into field B it doesn't work.

Any ideas?

Thank you!

Chris

Labels (1)
11 Replies
marcus_sommer
MVP
MVP

I meant a search-string with the pipe as delimiter of the values and not just the exported dimension-values. Personally I don't need this very often in QlikView itself. Quite common are such search-strings instead with outside-values from users who needs data/views to a certain dataset. Mostly they are coming as excel-list or per mail and I create then the search-string in excel - it just needs a few seconds with an excel-expression.

In your case I would use like above mentioned an action which does the selection do. Further I could imagine to avoid these selections completely by adjusting my expressions appropriately, maybe with something like:

sum({< FieldA = p(FieldB) >} Value)

- Marcus

Anonymous
Not applicable

I agree with Marcus. 

The only time I've even considering copying and pasting was when I had a longer list of values from a customer that I wanted to research in my dashboard on a detail level sheet.

For that I created an input box tied to a variable.  A user could just copy and paste a list from Excel without worrying about pipes or anything.

Then I had another variable based on that that added the pipes and whatnot.

Then I tied an action to a button that would apply the search.

But I never tested it copying from one object to another.