Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Copy and paste from external source

Hi,

Is it possible to copy from an external source and paste this list into a search field?


The external source is Excel - and the Qlikview solution that we have is not Integrated with office.

the list would often consist of materiale nummers.

Thanks in advance

/Martin

12 Replies
sushil353
Master II
Master II

Hi,

Yes, you can copy and paste from external source in qlikview..

But, i am unable to understand your requirement/issue.

HTH

Sushil

Not applicable
Author

Hi,


The question that I might have forgotten to ask was; How can I copy and paste into a search field.

Thanks in advance

/Martin

its_anandrjs

Hi,

The search string would be copy from the source location and paste into the search object by copy and paste you have to do that thing.

Hope this helps

Thanks & Regards

Not applicable
Author

Hi Again,

Yes for one materiale nummer I can easily copy and paste.

But what when I have a list of 250 materials? How then to copy the list and paste it into the search field?

Thanks in advance


/Martin

its_anandrjs

Hi,

It is difficult but in your search object type 'yourfieldvalue1 yourfieldvalue2 yourfieldvalue3 yourfieldvalue4 yourfieldvalue5 .... and so on but if values are large i suggest do this searching in any other QVW application with joins(inner,outer,left,right) and so on if you are doing data modelling or any analysis. This option would be better other wise i suggest copy from excel file and use like this  'yourfieldvalue1 yourfieldvalue2 yourfieldvalue3 yourfieldvalue5.....yourfieldvalue250 but it is difficult not a good practice.

Hope this helps

Thanks & Regards

Not applicable
Author

Hi Martin,

You have to create first Text object and then see screen shot attached.

In my case I am copy & paste list of account number from excel and its generate report only for copied accounts.

copy&Paste.png


ThornOfCrowns
Specialist II
Specialist II

What's preventing you from getting this data directly from the Excel file?

Not applicable
Author

Hi,

Thanks for your reply.

I had the extact same though in mind, however, it is not so flexible for the users.

/Martin

Not applicable
Author

Hi Vinay,


Looks like the solution that I have been looking for.


Just one question - do I have to type this "replace" for as many values that I expect to be copy/pasting? - or does your example allow me to copy and paste a list of 500 material numbers, or in your case 500 account numbers

Thanks in advance

/Martin