Discussion Board for collaboration related to QlikView App Development.
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
go to edit script --> insert-->load statement-->load inline-->pop up the window inline data wizard-->paste your column here one by one
and on F1 side Write your Column name and same for other column
then reload it hope it helps
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.
Are there any Macros/plugins available of some sort , which can help us develop the same ?