Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can i upload excel file into qlickview?
i have excel files like
1) Employee.xls
2)Sales.xls
help me out for this..
ctrl+e for script editor
at the bottom choose Data tab
click Table Files button
choose the excel file (xls or xlsx)
follow the File Wizard
Hi
On the edit scrip to select
and choose the path where is it.
or
LOAD *
FROM
(ooxml, no labels, table is Sales);
and reload
i hope help you
Regards
Hi,
Click on Edit Script or Ctrl E 😆 Under Bottom Data Tab 😆 Click on Table files 😆 Select the excel file 😆 Make necessary changes 😆 Save the file.
Hope it helps!!
in excel sheet i dont have fields like country but i did't have country in selection feild ...how to solve
Hi,
I didn't understand could you please elaborate your requirement.
i have excel file of employee and sales xls already imported but i want to create a dashboard,but i need country field in any chart but i am not able to get country feild .
i have imported excel sheets but i am not having country feild in both excel sheets,but i need to consider country feild in qlickview....how it will be solved
Add country field details in Excel sheet, save and upload once again