topic Re: Copy and paste from external source in QlikView

Copy and paste from external source

Mon, 24 Mar 2014 09:08:26 GMT

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

Re: Copy and paste from external source

sushil353 — Mon, 24 Mar 2014 09:10:32 GMT

Hi,

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

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

HTH

Sushil

Re: Copy and paste from external source

Mon, 24 Mar 2014 09:13:14 GMT

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

Re: Copy and paste from external source

its_anandrjs — Mon, 24 Mar 2014 09:15:25 GMT

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

Re: Copy and paste from external source

Mon, 24 Mar 2014 09:39:57 GMT

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

Re: Copy and paste from external source

its_anandrjs — Mon, 24 Mar 2014 09:50:23 GMT

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

Re: Copy and paste from external source

Mon, 24 Mar 2014 09:57:10 GMT

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.

Re: Copy and paste from external source

ThornOfCrowns — Mon, 24 Mar 2014 09:59:17 GMT

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

Re: Copy and paste from external source

Mon, 24 Mar 2014 10:01:43 GMT

Hi,

Thanks for your reply.

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

/Martin

Re: Copy and paste from external source

Mon, 24 Mar 2014 10:04:24 GMT

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

Re: Copy and paste from external source

Mon, 24 Mar 2014 10:08:24 GMT

The users has to be able to search however the want to - therefor simply added the Excel file via the script is not an option. - plus we don't have a qlikview solution that has office integration.

/Martin

Re: Copy and paste from external source

Mon, 24 Mar 2014 10:19:30 GMT

there are no limits. you can copy as much as you want!

Vinay

Re: Copy and paste from external source

Mon, 24 Mar 2014 10:48:33 GMT

Hi Again,

It doesn't Work for me, I can't even add anything to the text box. Can I please see how you have created your text box - so that I can try an copy that solution for my data.

Thanks in advance

/Martin