Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

ronald_gdi
New Contributor III

Read file to selection in Ajax

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?

1 Solution

Accepted Solutions

Re: Read file to selection in Ajax

Hi have you look at my  attachment CopyPasteSearch.qvw

Regards

ASHFAQ

12 Replies
Employee
Employee

Re: Read file to selection in Ajax

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

ronald_gdi
New Contributor III

Re: Read file to selection in Ajax

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

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

ronald_gdi
New Contributor III

Re: Read file to selection in Ajax

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

Not applicable

Re: Read file to selection in Ajax

!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

Hi,

Have a look at the attached application.

It simple and clean.

Regards

ASHFAQ

ronald_gdi
New Contributor III

Re: Read file to selection in Ajax

Thank you!

Great idea.

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

Kind Regards.

ronald_gdi
New Contributor III

Re: Read file to selection in Ajax

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

Hi have you look at my  attachment CopyPasteSearch.qvw

Regards

ASHFAQ

Community Browser