topic Re: Read file to selection in Ajax in QlikView

Read file to selection in Ajax

ronald_gdi — Mon, 26 Jan 2026 18:19:17 GMT

Today I use Qlikview Plugin in my applications.

I have an analysis where exists a macro that reads an excel file on the user's machine and reads the information in a column and select this data in Qlik and finally creates a bookmark with this selection. There have looked like alo using ajax mode?

I need to use the plugin today just for this feature, exists alternatives?

Re: Read file to selection in Ajax

Bill_Britt — Wed, 30 Jul 2014 17:15:16 GMT

Hi Ronald,

It is best to move away from macros and the reason for it is that most are not supported in AJAX. The local machine to AJAX is the server. So, I really don't know of a way to do this without the Plugin. Also, the future of the plugin is unknown at this time.

Bill

Re: Read file to selection in Ajax

ronald_gdi — Thu, 31 Jul 2014 18:57:07 GMT

Ok Bill, thanks.

But I have one situation.

The key user has a list of fifty customers or one hundred customers. It is most slowly select one by one. Is there any way to make this selection without selecting one by one?

Kind regards.

Re: Read file to selection in Ajax

ashfaq_haseeb — Sun, 03 Aug 2014 06:17:40 GMT

Hi,

Yes possible,

Have a look at the below posts.

http://community.qlik.com/docs/DOC-6828

http://community.qlik.com/docs/DOC-6707

Regards

ASHFAQ

Re: Read file to selection in Ajax

ronald_gdi — Tue, 05 Aug 2014 13:17:20 GMT

Thanks,

But I didn't have acess the second link. Does it exist?

I saw the first link, but my situation is different.

I don't know what the selections I have to do, ok?

The selections are in a file (csv, xls), but they are many selections and I need to select more quickly.

Today I use the IE Plugin with macro to input this file and selections more quickly.

Do you have any idea? Some similar in Ajax?

Kind regards

Re: Read file to selection in Ajax

Tue, 05 Aug 2014 13:21:22 GMT

!Hi,

You can try using the input box, where the user enters the list in a comma separated string. Then using the actions in a button you can try selecting the values in a field.

Just an idea. Never tried it.

Attached is a sample application. You can reformat the variable before using it in the actions.

Re: Re: Read file to selection in Ajax

ashfaq_haseeb — Wed, 06 Aug 2014 08:34:21 GMT

Hi,

Have a look at the attached application.

It simple and clean.

Regards

ASHFAQ

Re: Read file to selection in Ajax

ronald_gdi — Wed, 06 Aug 2014 23:05:43 GMT

Thank you!

Great idea.

I didn't see the attached application. Where is it?

Kind Regards.

Re: Read file to selection in Ajax

ronald_gdi — Wed, 06 Aug 2014 23:09:14 GMT

Sorry Syed.

You commented on the application that was in one of those two links?

I saw the application. I am testing that method.Thanks.

Kind regards.

Re: Read file to selection in Ajax

ashfaq_haseeb — Thu, 07 Aug 2014 05:13:51 GMT

Hi have you look at my attachment CopyPasteSearch.qvw

Regards

ASHFAQ

Re: Read file to selection in Ajax

ronald_gdi — Mon, 11 Aug 2014 13:49:55 GMT

Thank you ASHFAQ,

I tested the file. It is a alternative.

I will use this way to implement the functionality.

Kind Regards,

Ronald

Re: Read file to selection in Ajax

ashfaq_haseeb — Mon, 11 Aug 2014 13:50:46 GMT

Hi,

Can you close this thread.

Regards

ASHFAQ

Re: Read file to selection in Ajax

ronald_gdi — Mon, 11 Aug 2014 13:52:45 GMT

Of course.

Thanks!