Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to copy paste from Excel to Qlikview

Hi All,

I have a requirement where end user would like to Copy two columns with about 500 rows worth of data from excel to Qlikview.

What are the solutions available for the same ?

Loading data from Excel is not an option as amount of excel files and format with similar data is diverse.

What is the easiest way to allow end user to copy paste from Excel to Qlikview ?

Thanks in advance

Regards

Ravi

3 Replies
er_mohit
Master II
Master II

go to edit script --> insert-->load statement-->load inline-->pop up the window inline data wizard-->paste your column here one by one

then ok

and on F1 side Write your Column name and same for other column

then reload it hope it helps

Gysbert_Wassenaar

You cannot copy data from excel into qlikview. You will have to load the data from the excel file using a load statement in the script. In the file wizard you can select only those columns from the excel file you need.


talk is cheap, supply exceeds demand
Not applicable
Author

Are there any Macros/plugins  available of some sort , which can help us develop the same ?

Regards

Ravi