topic Re: Add spreadsheet in QlikView

Add spreadsheet

Thu, 16 Oct 2014 12:17:30 GMT

I have a app where the connection for data is to a SQL db.

Within the app i need one tab which shows data from an excel spreadsheet.

How can i do this?

Thanks

Re: Add spreadsheet

maleksafa — Thu, 16 Oct 2014 12:20:02 GMT

what do you mean excatly? because you can load an excel spreadsheet into qlikview very easily and then add a flag when loading from excel that this is coming from excel, and in your tab filter on the excel flag.

Re: Add spreadsheet

Thu, 16 Oct 2014 12:21:44 GMT

so I have a QVW where all the data is from a SQL db. I have a requirement to display the output of a excel file in one tab

Re: Add spreadsheet

its_anandrjs — Thu, 16 Oct 2014 12:22:19 GMT

Load that excel table individually to the data model like

Ex:-

LOAD

Country,

City,

Total

FROM

[Mapping table.xlsx]

(ooxml, embedded labels, table is Sheet1);